Forum Discussion
Percentage Calculation
Hello,
I'm new to Power BI and struggling mightily to figure this out.
I'm trying to create a percentage calculation for a population. I'm working with a large dataset where the numerical value field I'm trying to create the percentage of the population of, is the "Plan Payment Amount".
The field I'm trying to base the percentage of is the "Episode Category" field.
I'm ultimately trying to create a visualization card where depending of the slicers (Episode Category) and (Episode Description) will change the Percentage Calculation of the "Play Payment Amount"...based on the two slicers/filters I've referred to above.
I believe creating a measure would be the way to go...but I'm struggling with this. Can you assist?
Thank you!
AW
Hi, Anonymous
Based on your description, I created data as follows.
Table:
You can create a measure as follows. Finally, you can use the ‘Episode Category’ and ‘Episode Description’ columns as slicers to change the measure.
Plan Payment Amount =
DIVIDE(
SUM('Table'[Value]),
CALCULATE(
SUM('Table'[Value]),
ALLSELECTED('Table')
))
Result:
If I misunderstand your thought, please show me your sample data and expected output. Do mask sensitive data before uploading. I am glad to solve the problem for you.
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous
not sure what is "percentage" in your task but try to create a measure like
Measure = DIVIDE( calculate(sum(Table1[Plan Payment Amount])); calculate(sum(Table1[Plan Payment Amount]);all(Table1)) )do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi, Anonymous
Based on your description, I created data as follows.
Table:
You can create a measure as follows. Finally, you can use the ‘Episode Category’ and ‘Episode Description’ columns as slicers to change the measure.
Plan Payment Amount =
DIVIDE(
SUM('Table'[Value]),
CALCULATE(
SUM('Table'[Value]),
ALLSELECTED('Table')
))
Result:
If I misunderstand your thought, please show me your sample data and expected output. Do mask sensitive data before uploading. I am glad to solve the problem for you.
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try
Measure = DIVIDE( calculate(sum(Table1[Plan Payment Amount])); calculate(sum(Table1[Plan Payment Amount]),all(Episode[Episode Category]),all(Episode[Episode Description])) )Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
