This is my first time posting here so please forgive me if I'm not explaining things correctly.
I'm using Version: 2.121.644.0 64-bit (September, 2023)
I have this measure
"Measure = SWITCH(MAX('Age Parameter'[Age Parameter]), "0-5", SUM('Risks by Age'[0-5]), "6-11", SUM('Risks by Age'[6-11]), "12-17", SUM('Risks by Age'[12-17]), "18-24", SUM('Risks by Age'[18-24]), "25-29", SUM('Risks by Age'[25-29]), "30-39", SUM('Risks by Age'[30-39]), "40-49", SUM('Risks by Age'[40-49]), "50-59", SUM('Risks by Age'[50-59]), "60-69", SUM('Risks by Age'[60-69]), "70-79", SUM('Risks by Age'[70-79]), "80-99", SUM('Risks by Age'[80-99]), "12-29", SUM('Risks by Age'[12-29]))"
For the visual at the bottom left, I want it to show me the percentage for each year. I tried the 'Show Value As -> Percent of grand total' but that just gives me the percent of all the years added together which is not what I want to happen. I've been Googling for answers but I can't seem to find what I need. Can someone please direct me on what I should do please?
I'm using Version: 2.121.644.0 64-bit (September, 2023)
I have this measure
"Measure = SWITCH(MAX('Age Parameter'[Age Parameter]), "0-5", SUM('Risks by Age'[0-5]), "6-11", SUM('Risks by Age'[6-11]), "12-17", SUM('Risks by Age'[12-17]), "18-24", SUM('Risks by Age'[18-24]), "25-29", SUM('Risks by Age'[25-29]), "30-39", SUM('Risks by Age'[30-39]), "40-49", SUM('Risks by Age'[40-49]), "50-59", SUM('Risks by Age'[50-59]), "60-69", SUM('Risks by Age'[60-69]), "70-79", SUM('Risks by Age'[70-79]), "80-99", SUM('Risks by Age'[80-99]), "12-29", SUM('Risks by Age'[12-29]))"
For the visual at the bottom left, I want it to show me the percentage for each year. I tried the 'Show Value As -> Percent of grand total' but that just gives me the percent of all the years added together which is not what I want to happen. I've been Googling for answers but I can't seem to find what I need. Can someone please direct me on what I should do please?