Filter and previousmonth returns blank

[Stawik]

Hi I have problem with dax formula.

It looks like that

M-1 VOL = CALCULATE(SUM(Wnioski[Vol]); FILTER(Wnioski;Wnioski[ProductType] <> "Phones"); PREVIOUSMONTH(Data[DATE]))

And the result is blank, no errors

When I remove FILTER(Wnioski;Wnioski[ProductType] <> "Phones") then it works fine, also when I remove

PREVIOUSMONTH(Data[DATE])) it works fine, but together it do not work.

What I'm doing wrong?

[v-lili6-msft]

HI, @Stawik 

For your case, Just add ALL Function or ALLSELECTED Function in your formula as below:

M-1 VOL = CALCULATE(SUM(Wnioski[Vol]); FILTER(ALL(Wnioski);Wnioski[ProductType] <> "Phones"); PREVIOUSMONTH(Data[DATE]))

or

M-1 VOL = CALCULATE(SUM(Wnioski[Vol]); FILTER(ALLSELECTED(Wnioski);Wnioski[ProductType] <> "Phones"); PREVIOUSMONTH(Data[DATE]))

Then it will work well.

Regards,

Lin

[Stawik · Accepted solution]

HI with All it works better, but not ideal. Fortunatelly I have found workarround.

I have create two measures

VOL2 = CALCULATE(SUM(Sales[Vol]); FILTER(Sales;Sales[Typ produktu] = "Phones"))

Measure3 = CALCULATE([VOL2];PREVIOUSMONTH('Date'[DATE]))

And now Measure3 shows the data i need

[v-lili6-msft]

hi @Stawik 

---

@Stawik wrote:

HI with All it works better, but not ideal. Fortunatelly I have found workarround.

I have create two measures

VOL2 = CALCULATE(SUM(Sales[Vol]); FILTER(Sales;Sales[Typ produktu] = "Phones"))

Measure3 = CALCULATE([VOL2];PREVIOUSMONTH('Date'[DATE]))

And now Measure3 shows the data i need

---

It's pleasant that your problem has been solved, could you please mark the reply as Answered?  

Regards,

Lin

[amitchandak]

Will you able to share a sample pbix file after removing sensitive information. Typically it happens when there are non-continuous dates.

[Stawik]

Hi amitchandak

Thanks for your help.

This is link to example file

https://isolutionpolska-my.sharepoint.com/:u:/g/personal/dstawicki_isolution_pl/EbvZneqJhw9IiNfxyl6a...

Best regards

Daniel Stawicki