Forum Discussion
Anonymous
3 years agoNot applicable
Highlight Maximum Test Time Based on Specific Criteria in Table.
Hi Power Bi Expertise, Need your helps on how to highlight in table for maximum test time based on specific criteria? Mean
- 3 years ago
Hi Anonymous ,
Pls use measure like the below:
test = IF ( MAX ( 'Table'[Test Time U] ) = CALCULATE ( MAX ( 'Table'[Test Time U] ), FILTER ( ALL ( 'Table' ), 'Table'[Machine] = MAX ( 'Table'[Machine] ) && 'Table'[Model Categroy] = MAX ( 'Table'[Model Categroy] ) ) ), "Red" )Then format:
Best Regards
Lucien
v-luwang-msft
Community Support
3 years agoHi Anonymous ,
Pls use measure like the below:
test =
IF (
MAX ( 'Table'[Test Time U] )
= CALCULATE (
MAX ( 'Table'[Test Time U] ),
FILTER (
ALL ( 'Table' ),
'Table'[Machine] = MAX ( 'Table'[Machine] )
&& 'Table'[Model Categroy] = MAX ( 'Table'[Model Categroy] )
)
),
"Red"
)
Then format:
Best Regards
Lucien