cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)