Forum Discussion
DAX 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.
This goes on all the way to week 52.
Now I only have data for financial week 45 & 46 so was only expecting to see 2 rows with a score for week 45 (which should have been 66.73) and a score for week 46 (which should have been 48.78).
Here is the DAX that is giving me this value:
=([Percentage of Promoters]-[Percentage of Detractors])*100The data model has a relationship between the 'date' table and my 'scores' table linking 2 'date' columns together.
Any help regarding this would be greatly appreciated.
Paul Mac
4 Replies
Hi 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
Generally this indicates that you are missing a relationship between tables. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg_Deckler
Thanks for the swift reply.
See below that my 'date' table's date column is pointing to the date column of my 'scoring table' (Service Tick).
If this is incorrect, then please advise a correct method.
