Forum Discussion
Divide measure
Hello,
Trying to show this on a pie chart, need help with a measure in percent value....
Need help with a measure in percent value....Total all Patients = Virtual+Telephone+Onsite
Total ALL Patients (a measure with sum of diff Patients) / total virtual patients
300000 / 66000 = X %
Total ALL Patients (a measure with sum of diff Patients) / total Telephone patients
300000 / 4000 = Y %
Total ALL Patients (a measure with sum of diff Patients) / total Onsite patients
300000 / 200000 = Z %
Please advise if you can.
Thank you!
I was able to figure this out, just used the quick measure and that worked. Thank you!
3 Replies
sraj Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Hi sraj ,
Are you sure you want the Total ALL Patients / total virtual/Telephone/Onsite patients? The result will be greater than 100%, how do you put them into the pie chart?
Best Regards,
Jay
I was able to figure this out, just used the quick measure and that worked. Thank you!
