Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
Thanks for the reply.
I forgot to mention I am rather new to DAX coding, I have taken over this dashboard from a previous person and I was copying over code from their dashboard to mine, so if they used SUMX somewhere, I used it there too. Are you saying that I do not need to use SUMX in this code?
To answer your other questions, I want a DAX code that gives me the percentage of respondents that have answered each category across a wave. For example: How many people chose "Price" during Wave 113.
TR6 Top None is my attempt at writing a code that gives me the correct results when none of the filters are applied, however when any of the slicers are selected, the results are not right.
TR6 Top ALL is to show a code that I have used in other parts of my dashboard and the filters are working correctly. For example, I can apply a filter of Females Aged 16-25 from NSW and I can be sure that the data has been filtered correctly.
Top Sex, Age, and State measures are the same as the other two, but with only the corresponding filter as their title.
VALUES(MAT_Rank_Top_TR6[SC1]),VALUES(MAT_Rank_Top_TR6[Age_Brackets]),VALUES(MAT_Rank_Top_TR6[State]