Percent of Total based on Flags

[shelbsassy]

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!

[Greg_Deckler]

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

[shelbsassy]

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.

[Greg_Deckler]

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.

[shelbsassy]

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.

[Greg_Deckler]

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

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

[shelbsassy]

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

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

[Greg_Deckler]

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.

[shelbsassy · Accepted solution]

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

[v-huizhn-msft]

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

[Greg_Deckler]

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.

[shelbsassy]

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

[shelbsassy]

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?

[Greg_Deckler]

Please provide sample data.