Measure that depends on two other measures that themselves depend on filters

[Imad-R]

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 !!!

[amitchandak · Accepted solution]

@Imad-R , One of the tables need to be independent

refer

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

[amitchandak · Accepted solution]

@Imad-R , One of the tables need to be independent

refer

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

[Imad-R]

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?

[v-mengzhu-msft · Accepted solution]

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