Percentage Calculation

[Anonymous]

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

[amitchandak]

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-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[v-alq-msft · Accepted 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.

[az38]

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