The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to Solution.
The card visual has no concept of SELECTEDVALUE. Use a different aggregation.
Thank you for your help. I use your code for the running total and now it is working!
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
Hello,
Thank you for the code. The code for the running total is working but I still get (BLANK) as result in the card.
Thank you for your help. I use your code for the running total and now it is working!
The card visual has no concept of SELECTEDVALUE. Use a different aggregation.
Consider the filter context. Show your measure code.
Hello,
The code I use for the running total is
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |