Forum Discussion
Help with Slicers, and All function affecting totals for calculations.
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...
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
Community Support
Community SupportHi 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.