Count based on Conditional Formating

[eierkopf]

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]

hi @eierkopf 

what filter context do you have for the screenshot?

they have to be reflected in the count measure. 

[eierkopf]

Hi @FreemanZ 

Sorry here a better overview of the dashboard:

The count should be recounted everytime a filter changes.

Thank you.