cancel
Showing results for
Did you mean:
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
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])))

13 REPLIES 13
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

Proud to be a Datanaut!

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

## 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

Proud to be a Datanaut!

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.

Super User

## Re: Percent of Total based on Flags

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Super User

## Re: Percent of Total based on Flags

Member,Flag

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

Created these measures:

```MemberFlagCount = COUNT([Member])

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

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

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?

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])

Highlighted
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

Proud to be a Datanaut!

Announcements

#### 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

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

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)