Measure to ignore a field

[MagikJukas]

Hello,

I have these two measures:

M1= CALCULATE(SUM(Data[Qty]),FILTER(ALLSELECTED('Date list'[Date]),'Date list'[Date]<=MAX('Date list'[Date])))

M2= CALCULATE(SUM(Data[Qty]),FILTER(ALLSELECTED(Data[Data type]),Data[Data type]="3p"))

when I create a chart, M1 shows only values associated to 3p. I want M1 to ignore "Data Type" and to show the total for all Data Type.

thanks

[MagikJukas · Accepted solution]

Well, this is an embarassing one....

I just noticed my chart created a second vertical axis. I was looking the left one striggling to understand why the numbers are not matching. I now realized that the axis was moved to the right... 🤣

sorry guys! your solution work, but they are not necessary. thanks

[Anonymous]

Hi @MagikJukas ,

Please try below dax formula:

M1= CALCULATE(SUM(Data[Qty]),FILTER(ALLSELECTED('Date list'[Date]),'Date list'[Date]<=MAX('Date list'[Date])),REMOVEFILTERS('Data'[Data type]))

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

hi @MagikJukas 

try like:

M1= CALCULATE(SUM(Data[Qty]),FILTER(ALLSELECTED('Date list'[Date]),'Date list'[Date]<=MAX('Date list'[Date])), ALL(Data[Data Type]))