cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tjlundquist1
Helper I
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.  

 

tjlundquist1_0-1637348934198.png

 

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
v-henryk-mstf
Community Support
Community Support

Hi @tjlundquist1 ,

 

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%?


 Looking forward to your feedback.


Best Regards,
Henry

 

@v-henryk-mstf 

 

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

tjlundquist1_0-1637592288559.png

 

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.

tjlundquist1_1-1637592345897.png

 

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.

tjlundquist1_2-1637592457261.png

 

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

 

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

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

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors