Drill-through not filtering because of DAX Measure

[Anonymous]

Hello, 

I have trouble understanding what is happening in my report (which is pretty basic) :

1) I don't understand why in my table in page1 I have so many rows where Score Average = 0. Score Average is a measure that calculates the average score of a plateforme. This measure may be incorrect.

2) I don't understand why I have different TestID in my visual table when I bring TestID (Fact) in the table. We have one testID for one plateforme. The column TestID (Fact) in the visual table is wrong. I realized this problem when I wanted to Drill-through from page1 (right click on FNAC that has a score average different from 0 and go to Details) to Details page where I saw URLs that don't correspond to FNAC but also to other plateformes... (drill-through not working?? I don't think so, I think my measure is wrong).

How can I have the correct number of rows and the correct TestID (Fact) ? Is there a problem in my datamodel?

Thank you very much for your help, here is the link to the pbix file : https://www.dropbox.com/s/vdb1mzcnfurnpbe/Sample%20eco%20score.pbix?dl=0 

Best regards

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

I took a look at your PBIX and answered your two questions:
1) You said the average score was 0. I didn't see that. Is that it?

2) We have one testID for one plateforme, I see the data, it is not so, such as Mcdo corresponding to 4 ID; HSBC has 3 ID.

In addition, FNAC corresponds to more than one URL, as shown in the figure. 

Therefore, there is no problem with your drill through, mainly due to your data.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SanketBhagwat]

Hi @Anonymous .
Please check if the below option is enabled on your Power BI Desktop.

Also, I just checked your file, you were taking Count of Test ID(dim Test) in your table.
Please mark it as 'don't summarize'.
Follow the above mentioned steps, and then let me know if it is working or not.

If yes, then mark this as 'Accept as Solution' so that it could help others.

Regards,
Sanket

[Anonymous]

Hi Saket,

Thank you for your suggestions but this is not working because the drill-through is not cross-report (but inside a same report) and the summarization in my file is "don't summarize" it is weird that for you it is different.

I think the problem comes from the DAX measures Score Average.

Best regards