Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I have problem with dax formula.
It looks like that
Solved! Go to Solution.
HI with All it works better, but not ideal. Fortunatelly I have found workarround.
I have create two measures
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
HI with All it works better, but not ideal. Fortunatelly I have found workarround.
I have create two measures
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
Will you able to share a sample pbix file after removing sensitive information. Typically it happens when there are non-continuous dates.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |