DAX Measure to count row with particular background cell color.

[Anonymous]

Hello PBI community, I have a table with a column contains different color of cells, I want to write a DAX measure to count a particular cell color. For eg. the Column name is Contract and has a different color like Red, Blue, Green, Yellow. Ideally, I want to count row the number of cells with a yellow specific color in a card visual. Can anyone from the community give me a hand to create a DAX measure?

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

You will have to have a unique identifier for each color.  If you table is simple, you could create a new column, and write yellow, green, etc. Then  CALCULATE (Countrows(Your Table Name) , Your Table Name[Color Column = "Yellow").

If it is extensive, follow this video that shows you a quick way to find the numerical rendering of a color and fill the column in with a unique number. https://www.youtube.com/watch?v=cbfLU1s2V6U. Then instead of "Yellow" you will use that number.

You can then drop that measure on a card.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel