Display a running total percentage on a card

[boa]

Hello

I'm trying to get a running total percentage on a card in a PowerBi report but I get a blanco card.

I have a measure for the running total and for the running total percentage. 

I get this matrix:

I want to show the Running Total Percentage of category 3 on a card. (a card with 72,04% on it)

Do I have to make a new measure for this card? I tried some but get always (BLANK) on the card.

Many thanks in advance for help!

[lbendlin · Accepted solution]

The card visual has no concept of SELECTEDVALUE.  Use a different aggregation.

[v-cgao-msft]

Hi @boa ,

Please try:

Running total percentage 3 = 
VAR __numerator = CALCULATE([running total],'Table'[Tijd tss boeking&afspraak_catnr]=3)
VAR __denominator = CALCULATE([running total],ALL())
VAR __result = DIVIDE(__numerator,__denominator)
RETURN
__result

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[boa]

Hello,

Thank you for the code. The code for the running total is working but I still get (BLANK) as result in the card.

[boa · Accepted solution]

Thank you for your help. I use your code for the running total and now it is working!

[lbendlin · Accepted solution]

The card visual has no concept of SELECTEDVALUE.  Use a different aggregation.

[lbendlin]

Consider the filter context.  Show your measure code.

[boa]

Hello,

The code I use for the running total is

running total =

CALCULATE (

    SUM ( 'data afspraken - PBI'[Aantal] );

    FILTER (

        ALLSELECTED ( 'data afspraken - PBI' );

        'data afspraken - PBI'[Tijd tss boeking&afspraak_catnr] <= SELECTEDVALUE ( 'data afspraken - PBI'[Tijd tss boeking&afspraak_catnr] )

            && 'data afspraken - PBI'[Start_jaar] = MAX ( 'data afspraken - PBI'[Start_jaar] )

    )

)