Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have many fields in my visuals.
I have high-level KPIs and chart KPIs.
For the % of the total, I need to calculate against either:
Skill Name OR
SLA Buckets
Here is what works in a table:
% of Total: = DIVIDE([Total SLA Buckets],[Total SLA],0)
Solved! Go to Solution.
Hi @angela_marie ,
Since you need to calculate % of Total for "Clinical", "Equipment", and "Mechanical Room" separately, create individual measures for each. For example, for "Clinical":
% of Total Clinical =
DIVIDE(
CALCULATE(
COUNT('SL_Data'[SLA Bucket]),
'SL_Data'[Skill Name] = "Clinical"
),
CALCULATE(
COUNT('SL_Data'[SLA Bucket]),
ALL('SL_Data')
),
0
)
If the results are not as expected, could you please provide more details?
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
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 -- China Power BI User Group
Hi @angela_marie ,
Since you need to calculate % of Total for "Clinical", "Equipment", and "Mechanical Room" separately, create individual measures for each. For example, for "Clinical":
% of Total Clinical =
DIVIDE(
CALCULATE(
COUNT('SL_Data'[SLA Bucket]),
'SL_Data'[Skill Name] = "Clinical"
),
CALCULATE(
COUNT('SL_Data'[SLA Bucket]),
ALL('SL_Data')
),
0
)
If the results are not as expected, could you please provide more details?
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
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 -- China Power BI User Group
I figured out how to make it work, but now I am having issues with the tool tip hover. The % of total works on one field but not on the other.
@angela_marie it is confusing, maybe post some sample data with the expected output, or share sample pbix file using one drive/google drive, remove any sensitive information before sharing.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.