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 work in Cards.

Any Idea?

Please see Images and below Measures.

_Label_Display = if(SELECTEDVALUE(Sheet1[Out OR NotOut])="N","*","")

 
_Label_Out_Notout_For_Chart = [_Runs] & [_Label_Display]   Note: This working OK. 
 
_Label_Out_Notout_For_Cards = [_Max_Run] & [_Label_Display]    Note:Not working
 
Hope this helps!
 
Regards
Vinay
Data FileCards Does not show * (Not Out)
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.

4 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi vinay_naran -Create a measure that calculates the maximum run and appends the * for "Not Out" directly within the same measure.

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

     

    you can use this measure in your card vis.using this measure in your card, you should be able to achieve the desired output

     

    Hope this helps.

      • rajendraongole1's avatar
        rajendraongole1
        Super 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.