Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |