Help with Slicers, and All function affecting totals for calculations.

[Anonymous]

Hi I hope someone can help.   I am trying to show the percentage of events from a total number of events once they have been affected by slicers.  Each row of data has a unique person ID, a LA, event "type", Age, gender code, and ethnicity codes.  The data is running from one main table, with the  UniqueID,  "event type", Age, and has look up tables to gender, Ethnicity.  

I  have set up the measure to "count the number ID's"  

ID's filtered = COUNT(main_flatcin[PersonID])

and the demoniator the total number of ID's below and divided them...

ALL  IDS =

CALCULATE(COUNT(main_flatcin[PersonID]),All(gender[Name]),All(Eth[Ethnicity Grp 1]),ALL(main_flatcin[Age (rounded)]),AlL(Eth[Ethnicity Description]))

I've set up the visual so it can show by one LA, and all the event types, and a slicer on ly affecting the chart on the right hand side where the event type can be selected and shows all LA's.    The total for this selection is 7471, but when I change the Age filter, it changes the total, and is not calculating the percentage correctly. 

[Anonymous · Accepted solution]

Thanks both for your suggestions, unfortunately, these didn't work but I think it was the way my data was set up I created a new reference table, with unique ages and used that in the slicer, and change the All statement to include the column if that makes any sense. 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Simple-ALL-function-not-working/m-p/905745

[v-lionel-msft]

Hi @Anonymous ,

Or try this.

ALL  IDS =
CALCULATE(COUNT(main_flatcin[PersonID]),AllSELECTED(gender[Name]),AllSELECTED(Eth[Ethnicity Grp 1]),AllSELECTED(main_flatcin[Age (rounded)]),AllSELECTED(Eth[Ethnicity Description]))

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , try all IDS like

CALCULATE(COUNT(main_flatcin[PersonID]),All(gender),All(Eth),ALL(main_flatcin))