topic Re: Count based on Conditional Formating in DAX Commands and Tips

Count based on Conditional Formating

eierkopf — Wed, 11 Jan 2023 14:27:41 GMT

Hi together

My target is to count cells based on the background color.
The background color is done via conditional formatting.

For the conditional formatting I have a measure:

SWITCH(

TRUE(),

[TGS Full PY [nom]]] > SELECTEDVALUE('MASTER MKT_Targets'[Target]),"#E7FFDE",

[TGS YTD [nom]]] > SELECTEDVALUE('MASTER MKT_Targets'[Target]),"#73B761",

[TGS YTD [nom]]] < SELECTEDVALUE('MASTER MKT_Targets'[Target]),"#EB9534"

)

So my Dashboard looks as follows:

Now I want to count the cells based on the background color.
I tried a few things but nothing worked for me.

Help is very appreciated and thanks in advance.

FreemanZ — Wed, 11 Jan 2023 14:42:36 GMT

what filter context do you have for the screenshot?

they have to be reflected in the count measure.

eierkopf — Wed, 11 Jan 2023 14:49:28 GMT

Sorry here a better overview of the dashboard:

The count should be recounted everytime a filter changes.

Thank you.