Power BI Conditional Format

[azakir]

Hi Guys. Looking for some help on conditional formatting and counting of measure.

I have the following table: 

In a matrix visual, I would like to conditional format just the row total based on the values of subcategory. Regardless of the total, if two thirds (2/3) of overall subcategories met the target, I would like to conditional format the row total as green. In the example below, Drill has 5 subcategories. Even though overall Drill category failed to meet the target, but because 3 out of 5 subcategories did meet the target, I would like to change it to green. 

** Achieved = if( [Actual] >= ([Target] * 0.667), 1,BLANK())

Is there a way I could also count the number of rows that have achieved 1 for the measure.

So something along the lines of:

CALCULATE( COUNT(EQ Code), **Achieved = 1)

[Ahmedx · Accepted solution]

Is this what you are looking for?
https://1drv.ms/u/s!AiUZ0Ws7G26Rhhi5XjS05sJYeyNX?e=zcn3TL

[azakir]

Hi @Ahmedx Exactly what I was looking for. Thanks for providing with the PBIX as well. 

[amitchandak]

@azakir , Based on what I got, you can use measure based conditional formatting

example

Measure =
Switch(true(),
max(Table[status]) = "In production" , Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
) ,
max(Table[status]) = " Product completed" , Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)

Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...