Metric To retrieve a number and conditional formatting

[NewbieJono]

Hello, what DAX would i need to return the volume of 1-2 days % figure of 99.9951%

also is there a method of highlighting the row 1-2 days only

[Abysshek]

Is there a way to conditionally format the measure TAT 4D, if TAT 4D> Target, then green, or else red? Also the target will change if I change the filter branch. so it needs to be dynamic

[v-jingzhan-msft · Accepted solution]

Hi @NewbieJono 

Is your [%] a measure or a column? If it is a measure, you can create a measure like below to get the value

% of 1-2 Days = CALCULATE([%], 'TableName'[day]="1-2 Days")

If [%] is a column, you can try a measure like below (assume that you select max for the value in the current matrix)

% of 1-2 Days = CALCULATE ( MAX ( 'TableName'[%] ), 'TableName'[day] = "1-2 Days" )

You can use conditional formating feature to highlight some values in a matrix. It seems there are three value fields (vol, cumulative, %) in the matrix now. As the conditional formatting is only available for values, not for row/column, you need to set the conditional formatting for every value field one by one. 

For example, you can create a measure for color. Use this measure for color formatting all value fields. However, the row header cannot be formatted like this. And it doesn't support to highlight a specific row header value currently.

color measure = IF(SELECTEDVALUE('Table'[day])="1-2 Days","#EFB5B9")

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!