cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
shelbsassy Member
Member

Re: Percent of Total based on Flags

After many trials and tribulations I finally got it to work.  Not sure I understand the logic but I'll take it.  Thanks for the help!

 

PercentMembers = CALCULATE('Members Claims'[# Members]/CALCULATE('Members Claims'[# Members],ALLEXCEPT('Members Claims','Members Claims'[Carrier_id])))

View solution in original post

Super User
Super User

Re: Percent of Total based on Flags

Yep, that looks better. Your demoninator is calculating your measure in the context of all items in Members Claims except it is honoring any filter on Carrier_id column. The numerator calculates your measure in the full context of the filters on the visual/report/page.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

shelbsassy Member
Member

Re: Percent of Total based on Flags

Thank you for the explanation.  I was able to create 2 similar calculations using the logic from the explanation.  Appreciate the help!

Microsoft v-huizhn-msft
Microsoft

Re: Percent of Total based on Flags

Hi @shelbsassy,

Congratulations, you have resolved your issue by yourself. Please mark your solution as answer. So that other people benefit from it and find workaround clearly.

Thanks,
Angelia

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,224)