topic Re: Measure to ignore a field in DAX Commands and Tips

Measure to ignore a field

MagikJukas — Wed, 18 Jan 2023 19:35:57 GMT

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

Re: Measure to ignore a field

FreemanZ — Wed, 18 Jan 2023 23:19:33 GMT

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]))

Re: Measure to ignore a field

Anonymous — Thu, 19 Jan 2023 03:07:43 GMT

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.

Re: Measure to ignore a field

MagikJukas — Thu, 19 Jan 2023 08:18:35 GMT

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