Forum Discussion
PaulMac
Helper IV
Helper IVDAX Issue - Value The Same For All Financial Week Numbers
Hello All I have tried to make a list of scores per week but I appear to have gone awry somewhere as all I seem to get as a result is the same value accross all financial weeks. See photo below. ...
What is the definition of [Percentage of Promoters] / [Percentage of Detractors]? Is the DAX in those measures using ALL() on the scores table or something like that? That could lead to this result even if you have the relationship set up correctlty.
What is the definition of [Percentage of Promoters] / [Percentage of Detractors]? Is the DAX in those measures using ALL() on the scores table or something like that? That could lead to this result even if you have the relationship set up correctlty.
PaulMacHelper IV
Helper IVHi Anonymous
You were correct. I had a 3 DAX measures all using the ALL() function. After removing these the calcualtions work as intended, so thank you very much for pointing that out to me! 👍
Kind regards
PaulMac