Forum Discussion
Solved
Age Categories not working properly - leveling issue?
Hello: My goal is very simple - create "age categories" based on the Age2 measure field so that I can stratify by age groups. The code below works as indicated by the screenshot below. However...
Download Sample PBIX: Age Example
Hi, Are you trying to show result as shown? You can add an index column to your Age table and use your existing DAX to add your Groupings as a new colum. Results shown above.
MariaP
Solution Supplier
Solution SupplierDownload Sample PBIX: Age Example
Hi, Are you trying to show result as shown? You can add an index column to your Age table and use your existing DAX to add your Groupings as a new colum. Results shown above.
Yes, that's the outcome I'm trying to achieve. The Tabular Model is not available for me to alter, I have to use a calculated measure to achieve my desired result. I will try your idea above and I do appreciate your reply.