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
amitchandak
Super User
Super UserAnonymous , try all IDS like
CALCULATE(COUNT(main_flatcin[PersonID]),All(gender),All(Eth),ALL(main_flatcin))