Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Experts,
Can you help me with a measure so I can show the percentage by Service on the following bar chart:
So for Total Services, the % would be (by Illness Burden Category per example above):
The data looks like this:
And the Illness burden category is a field parameter:
When I switch to Age range and Gender, I also want the chart to show % of total by Service.
Thanks in advance 🙂
Soph
Hey @SophRow
Apologies for the confusion. The use of SUM('Table'[Count]) and [Total Count] in my previous response was incorrect. There is no difference between them, and it was an oversight on my part.
To clarify, you only need to create the "Total Count" measure using the formula. Hope this helps!
Hi @SophRow
I think the following steps should help in solving this problem:
Total Count = SUM('YourTable'[YourCount field])
Percentage by Service = DIVIDE(SUM('Table'[Count]), [Total Count])
Please cross check that you have the appropriate relationships established between the tables in your data model to ensure accurate calculations.
If this has solved your problem, please mark my post as solution.
Cheers
Thanks @data_freak - just a quick Q - for the % by service measure, what's the difference between SUM('Table'[Count]) and Total Count?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |