DAX Issue - Value The Same For All Financial Week Numbers

[PaulMac]

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])*100

The 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

[Anonymous · Accepted solution]

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.

[PaulMac]

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

[Greg_Deckler]

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

[PaulMac]

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.