cancel
Showing results for
Did you mean:
Helper I

## Measure that gives a % of the total of each variable each time you drill down to that variable

Trying to get a % of the total claims for each of the 3 levels. I have claim source, reported by and policy type. When I am all the way drilled up, the claims source currently displays the % of the total. But when I continue to drill down, the sub variables display a % of the total # of claims instead of the # of claims in it's respective category. EX: for After hours/ Overflow, the reported by Insured is 3104 of 3444 so am trying to get it to show 90%. So in the example, After hours should sho 4.06%, insured should show 90% of the After hours claims.

I hope I am making sense! Here's the mesure I am using currently. Hopefully it's something easy to change.

``% of Reported Claims = DIVIDE([# of Claims],CALCULATE([# of Claims],ALL('FNOL Email and Report Source Report')))``

Thanks for any help!

Trevor

2 REPLIES 2
Community Support

Can you explain my confusion, the screenshot shows what seems to be only two levels, followed by the calculation of the percentage of the corresponding level. Which judgment condition do you want to display the corresponding value based on? For example total=4.06%+83.70%, not100%?

Best Regards,
Henry

Helper I

The screenshot shows 3 levels, "Call Center" - "Agent" - "BOP Plus" for example. Here's a few more screenshots that hopefully helps clarify:

This is all the way at the top, so these all need to add up to 100% of the total

Then, level 2 - each of the sub sections so for example under call center, {Agent, Attorney, Claimant..etc} need to add up to 100% of Call Center. So with Agent having 37,729 it should be 53.18% of 70,950.

Then, level 3 - each of the sub sections so for example under call center, {BOP Plus, Commercial AgMax, Personal ..etc} need to add up to 100% of Agent. So with Personal having 34,277 it should be 90.85% of 37,729.

I hope that helps give some clarity - I should've given this to start. Thank you!

Announcements

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!