Cards - Display OUT Or NOTOUT in Cricket Application

[vinay_naran]

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)

[vinay_naran]

Hi @rajendraongole1 ,

Yes, that work like charm. 

Thanks you so much.

Regards

Vinay

[rajendraongole1]

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]

Hi @rajendraongole1 , 

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

Thanks

Vinay

[rajendraongole1 · Accepted solution]

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.