topic Measure that depends on two other measures that themselves depend on filters in DAX Commands and Tips

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

Imad-R — Wed, 16 Nov 2022 11:14:20 GMT

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

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

amitchandak — Wed, 16 Nov 2022 02:31:14 GMT

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

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

Imad-R — Wed, 16 Nov 2022 20:28:31 GMT

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?

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

Anonymous — Mon, 21 Nov 2022 09:02:09 GMT

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