IF – DAX Guide
https://dax.guide › ...Remarks. Using IF can generate multiple branches of code execution that could result in slower performance at query time. Then IF can return BLANK as one of ...
IF statement in Measure, need help - Power BI
community.powerbi.com › t5 › DesktopApr 15, 2021 · In DAX, Measure is always sliced by current row context, it's not possible to use the current slicing row as condition in Measure. In your scenario, you can create a dummy measure for this conditon. Just create a measure like: Dummy = SUM(Table[car_id]) Then you can create a calculated measure like: Measure =IF([Dummy]=112,22,[Measure_Gauge])