Can you set a calculated measure name/title dynamically based on a report filter/page

I would like to add a report filter/page value to the name of a measure. Instead of the measure name being static “JIRAs Filed”, I’d like it to be “Defects Filed” when ‘Defect’ is selected from the filter, or “Workarounds Filed” when ‘Workaround’ is selected from the filter. Is this possible?

Hi @hrwhohmann,

Welcome to the community :partying_face:!

Unfortunately, the name of the calculated measure can’t be changed based on the selection in the pages.

As a workaround, you can define several calculated measures, including a CASE statement that checks the particular page dimension value and returns a value with the desired one only. The “Hide empty columns” option then would hide all other measures.

So, when the Issue Type dimension is in the report pages, to see the “Bugs filed” measure, try the following formula:

CASE WHEN [Issue Type].CurrentMember IS [Issue Type].[Bug]
THEN
CumulativeSum([Measures].[Issues created])
END

Create similar calculated measures for other issue types. The report could look similar to the one below before enabling the “Hide empty columns” option:

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures.

Best,
Roberts // support@eazybi.com