Forum Discussion

vinay_naran's avatar
vinay_naran
Frequent Visitor
2 years ago
Solved

Cards - Display OUT Or NOTOUT in Cricket Application

Dear Friends, I am novice to Power BI and try to use CARDS with Player Highest Run and want to show if batter is OUT or NOTOUT (with *). Its working fine in charts, but same logic/measure does not ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi vinay_naran - Please check the below  measure:

    _Max_Run_With_Label =
    VAR MaxRun = MAX(crick[Runs])
    VAR IsNotOut =
        CALCULATE(
            MAX(crick[Out OR NotOut]),
            FILTER(crick, crick[Runs] = MaxRun)
        ) = "N"
    RETURN
        IF(IsNotOut, MaxRun & "*", MaxRun)

     

     

     

    This helps.

vinay_naran's avatar
vinay_naran
Frequent Visitor
2 years ago

Hi rajendraongole1 ,

 

Yes, that work like charm. 

Thanks you so much.

Regards

Vinay