Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |