Forum Discussion
Count Number of Values with Specific Color from Conditional Formatting
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!
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/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
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/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly