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 , 

I have tried with your measure but it NOT working in CARD. See Image below.

 

Thanks

Vinay

 

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
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.