Count Number of Values with Specific Color from Conditional Formatting

ok_kpop — Mon, 11 Sep 2023 22:16:29 GMT

I have this matrix visaul I created with conditional formatting where it will highlight any value in the "A" column for all days and times for any value that is greater than 25900. What formula can I use to find out how many values are colored red? I suppose it would involve the Count formula, but not sure how to create the measure for it. The name of the table is "Data" if you needed it. Thank you!

Re: Count Number of Values with Specific Color from Conditional Formatting

Ritaf1983 — Tue, 12 Sep 2023 03:00:02 GMT

Hi ok_kpop
You need to count by the same conditions that you gave to formatting.
Something like :
red_count = calculate (distinctctcount('your_table[id_value]), your_table[ab_value]="A" && sum('your_table[value]>25900)
If you need a more detailed and accurate formula Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

topic Count Number of Values with Specific Color from Conditional Formatting in Desktop

Count Number of Values with Specific Color from Conditional Formatting

Re: Count Number of Values with Specific Color from Conditional Formatting