Filter not applying to a measure?

[banksters]

Hello,

I have a table where one of the columns is represented by a measure. This measure will switch values depending on the value of another column in the table.

I have a calculated column that will return different colors based on the values in the Score column.

I applied conditional formatting to the Score column and based it on the Color Return Column calculated column, so that the background color of the column would change depending on what value it contains.

It works as shown above, but only when there are no filters applied. I have a dropdown that filters the data, and it seems like the Color Return Column calculated column is still returning values based on the Score column without any filters.

The second row should be returning red, and the third row should be returning yellow. Is there a way to have Color Return Column return colors based on values after filters are applied to the page?

[v-janeyg-msft]

Hi, @banksters 

When measure is used in the column, the context may change. There is no problem with your code. If you don’t provide sample data, it will be difficult for us to help you.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

[Greg_Deckler]

@banksters Hard to say without knowing what the formulas are for your measures [Score], etc.

[banksters]

Here are a couple of the formulas I am using.

Average Time Until Work Started =

SUM('TicketMetrics'[TimeToWorkStart]) / DISTINCTCOUNT('All tickets'[Tck_ID])

Average Time to Assign/Acknowledge =

SUM('TicketMetrics'[TimeToAssign]) / DISTINCTCOUNT('All tickets'[Tck_ID])

The dropdown I use to filter the data is filtering on a column in the "All tickets" table, where it's selecting a value ResponsibleGroupID to find tickets that belong to certain groups only.

[Greg_Deckler]

@banksters OK, but what is the [Score] measure formula? Because that is what seems to be messing up, yes?

[banksters]

Apologies, here is the [Score] measure.

Score =

IF (

HASONEVALUE ( 'IT Summary via New Table'[Metric] ),

SWITCH (

VALUES ( 'IT Summary via New Table'[Metric] ),

"Team Work Backlog", [Team Work Backlog],

"Average Time to Assign/Acknowledge", [Average Time to Assign/Acknowledge],

"Average Time Until Work Started", [Average Time Until Work Started]

)

)