Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
Before talking about my problem here is the data :
ID | Name product | Qty (per unit) | Price | Total | Week |
1 | Tomato | 5 | 2 € | 10 € | W-1 |
2 | Apple | 6 | 1,50 € | 9 € | W-1 |
3 | Fish | 3 | 3 € | 9 € | W-1 |
4 | Chicken | 2 | 5 € | 10 € | W-1 |
5 | Orange | 9 | 2 € | 18 € | W-1 |
6 | Fish | 4 | 1,50 € | 6 € | W-2 |
7 | Chicken | 1 | 5 € | 5 € | W-2 |
8 | Apple | 7 | 1,50 € | 11 € | W-2 |
9 | Carrot | 3 | 1 € | 3 € | W-2 |
10 | Egg | 12 | 0,30 € | 4 € | W-2 |
The following two tables will be useful for filtering :
Week F1 |
W-1 |
W-2 |
Week F2 |
W-1 |
W-2 |
The relationship is as follows :
After that I create 3 measure. I made a sum on everything that was bought in the first chosen week and another sum for the second week, and the last measure is the difference between the two measure. My problem is that when I change the filter nothing changes on the third measurement
except when the filters are selected on the same values.
I don't understand why this doesn't work and I have checked by managing the filter interactions but nothing works.
Please I need your help !!!
Solved! Go to Solution.
@Imad-R , One of the tables need to be independent
refer
How to use two Date/Period slicers
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
Hi @Imad-R ,
Relationships play an important role in power bi, and in many cases the correct configuration of relationships also affects the display of results. In your case, the existence of two week tables filtering the same table and establishing relationships can lead to conflicting filtering. Therefore, the relationship needs to be removed.
For documentation related to relationships see the following, which I hope will help you:
Relationship troubleshooting guidance - Power BI | Microsoft Learn
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Imad-R , One of the tables need to be independent
refer
How to use two Date/Period slicers
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
Hello and thank you for your response I've found the problem. I just deleted the relationships and know it's worked. But I don't understand exactly why I had to delete the relationships. Can you explain me, please?
Hi @Imad-R ,
Relationships play an important role in power bi, and in many cases the correct configuration of relationships also affects the display of results. In your case, the existence of two week tables filtering the same table and establishing relationships can lead to conflicting filtering. Therefore, the relationship needs to be removed.
For documentation related to relationships see the following, which I hope will help you:
Relationship troubleshooting guidance - Power BI | Microsoft Learn
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly