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!
Solved! Go to Solution.
Hi @boa ,
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
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!
The code I use for the running total is
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.