show percentage of total on matrix

[guanel1]

I am showing milestone status by percentages.

I want to only highlight the "ON TIME" row when it is less than 80%. My values are calcuating the Count of Milestone Status by percent of column total. 

Here is the rule i added: 

But I get this result: 

Issues: 

1. Why are the 100% and the 83.33% highlighted? 

2. How do I get only the "ON TIME" row to be conditionally formatted? When I filter out the LATE Column, then all the percentages become 100% (because it is based off column total)

[v-alq-msft · Accepted solution]

Hi, @guanel1 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure as below.

Result = 
DIVIDE(
    SUM('Table'[Value]),
    CALCULATE(
        SUM('Table'[Value]),
        ALLEXCEPT('Table','Table'[Year])
    )
)

Then you may conditional formatting 'Result' as below.

Result:

Best Regards

Allan

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

[guanel1]

Thankyou for your help! this worked.

[AllisonKennedy]

You may want to try creating explicit measures for this. If you only want the On Time percentage highlighted, create a measure for 

On Time Percentage =  

VAR _onTime = CALCULATE(COUNT(table[milestone status]), table[milestone status] = "On Time")

VAR _GT = CALCULATE(COUNT(table[milestone status]), ALL(table[milestone status]))

RETURN DIVIDE(_onTime, _GT)

then apply the conditional formatting to the NUMBER of the On Time Percentage measure.