Forum Discussion
DAX - Proportion Calculation across multiple groupings
Dear Power BI Community, I would like some help with the calculation of a proportion across multiple groupings. Shown below is the table I am working on. I have Age Categories running from...
Dear amitchandak,
Many thanks for your reply. Unfortunately, I don't think I was clear enough in my initial question.
I have mocked up the following table in Excel to detail exactly what I would like the DAX measure to produce.
You will see that I would like the proportion of each K10 category (Low, Moderate, High, Very High) as a function of the total for each Age Category.
Again, any assistance on how I can re-write my DAX expression to produce this would be wonderful.
Kind regards,
Joel