Hi everyone, I just give a try with a lated version of PowerBI Deskop
I met a weird situation, can anyone explain it to me?
I have a max value =0.0541, and I just want to create a color code for a row that contains the max value.
Here is my DAX:
GetMaxValue = MaXX(sn_test_data, CALCULATE(SUM(sn_test_data[Max creep_damage]),sn_test_data[Date]=Max(sn_test_data[Date])))
Max_Min Color = IF(
SUM(sn_test_data[Max cr_damage]) = [GetMaxValue],[GetMaxValue],"#118DFF"
)
Here is the result that is not what I want:
My goal is the "Max_Min Color" column which should be contain only one value 0.0541.
Thank you in advanced!
Hi @TrongPhuoc ,
Please try below steps:
1. create measure with below dax formula
Measure =
VAR max_date =
MAXX ( ALL ( 'Table' ), 'Table'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Date] = max_date )
VAR max_val =
MAXX ( tmp, [CriticalVal] )
VAR _a =
CALCULATETABLE (
VALUES ( 'Table'[order1] ),
FILTER ( tmp, [CriticalVal] = max_val )
)
VAR cur_date =
SELECTEDVALUE ( 'Table'[Date] )
VAR cur_order =
SELECTEDVALUE ( 'Table'[order1] )
RETURN
IF ( AND ( cur_date = max_date, cur_order IN _a ), 1 )
Measure 2 =
VAR max_date =
MAXX ( ALL ( 'Table' ), 'Table'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Date] = max_date )
VAR max_val =
MAXX ( tmp, [CriticalVal] )
RETURN
IF ( MAX ( 'Table'[CriticalVal] ) = max_val, "red" )
2. add table visual with fields
3. set visual level filter and conditional format for font color
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I have tried your suggestion, but it didn't work like my expectation.
Here the results:
Is there anyway we can apply loop for this case?
Best regards,
TrongPhuoc
Hi @TrongPhuoc ,
Please try below steps:
1. create measure with below dax formula
Measure =
VAR max_date =
MAXX ( ALL ( 'Table' ), 'Table'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Date] = max_date )
VAR max_val =
MAXX ( tmp, [CriticalVal] )
VAR _a =
CALCULATETABLE (
VALUES ( 'Table'[order1] ),
FILTER ( tmp, [CriticalVal] = max_val )
)
VAR cur_date =
SELECTEDVALUE ( 'Table'[Date] )
VAR cur_order =
SELECTEDVALUE ( 'Table'[order1] )
RETURN
IF ( AND ( cur_date = max_date, cur_order IN _a ), 1 )
Measure 2 =
VAR max_date =
MAXX ( ALL ( 'Table' ), 'Table'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Date] = max_date )
VAR max_val =
MAXX ( tmp, [CriticalVal] )
RETURN
IF ( MAX ( 'Table'[CriticalVal] ) = max_val, "red" )
2. add table visual with fields
3. set visual level filter and conditional format for font color
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
