Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Anonymous
Not applicable

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]