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

Percent of Total based on Flags

I am trying to get the % of members for each flag from the total number of members.  I have a measure # of members which is a Distinct count of membid.  When I display the Flag with # members it shows the members for each flag and then using the same # memebrs in a separate visual I show the total number of memebrs for the moth.  I am tryng to calculate the % of the memebrs for each flag out of the months total members.  I have tried a few things but I am pretty new at this.  I am stuck.  Any help would be awesome, thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
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

13 REPLIES 13
Super User
Super User

Re: Percent of Total based on Flags

I believe there is a Quick Measure for % of Total.


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

Unfortunately the quick measure only works to get the % of the total that were flagged.  I need the % of all the members, not just the ones flagged.

Super User
Super User

Re: Percent of Total based on Flags

How about creating a measure like this:

 

Measure1 = [Measure] / CALCULATE([Measure],ALL(Table))

Something like that, where [Measure] is your existing measure and Table would be the table that your measure deals with. The ALL removes all filter context and thus would grab all of the members regardless of Flag.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Highlighted
shelbsassy Member
Member

Re: Percent of Total based on Flags

Thank you, I tried that and it didn't work.  I need to keep the flags filter on it so I even tried removing the ALL but I end up with 100% for each column.  Here is a picture of what I am trying to calculate. The number of memebrs from the flags divided by the # members.  I just cant seem to make it work.Untitled.png

Super User
Super User

Re: Percent of Total based on Flags

Please provide sample data.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Super User
Super User

Re: Percent of Total based on Flags

For example, what I did to mock this up was this:

 

Member,Flag

1Flag1
2Flag1
3Flag1
4Flag1
5Flag2
6Flag2
7Flag2
8Flag3
9Flag3
10Flag4

 

Created these measures:

 

MemberFlagCount = COUNT([Member])

PercentMembers = [MemberFlagCount]/CALCULATE([MemberFlagCount],ALL('Members'))

 


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

I kind of see how this makes sense but Im not seeing where you are taking the filter of the Flag into play in the member flag count.  It looks like you are just counting the # members.  How can I count the number of members for a flag?

shelbsassy Member
Member

Re: Percent of Total based on Flags

I tried this but i get the cant display the visual.

 

PercentMembers = calculate('Members Claims'[# Members]('Members Claims'[Flag])/'Members Claims'[# Members])

Super User
Super User

Re: Percent of Total based on Flags

Can't do much without sample data but your formula does not look right at all. CALCULATE takes 2 parameters, what you want to calculate and then a filter. I don't see a comma in your formula so I have to believe that you are getting an error. Besides that, if that is a measure, you're going to need an aggregation like SUM or COUNT. See the measure formulas that I sent.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 124 members 1,686 guests
Please welcome our newest community members: