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.

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

  • 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.