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.
Hello everyone!
I'm facing a huge trouble while writing a DAX code for my PBI Report.
As you can see in the images when there's no month filter applied it computes correctly the Amount until May. However, whenever I click on any month in the report, it computes the clicked month value, instead of the running total until that month.
For example, if I click on April, instead of computing the values of Jan + Feb + Mar + Apr, it shows only the value for April.
If any kind heart can help me with that I would be really greatful. 🙂
Solved! Go to Solution.
You forgot the FILTER(ALL()) part when you specify all the previous months.
here's the pseudo code:
var currentmonth = selectedvalue(month)
return calculate(your calculations, filter (all(dates),dates[month]<=currentmonth))
Note: you may need to add a year filter if you have data for more than one year.
You forgot the FILTER(ALL()) part when you specify all the previous months.
Hi, Ibendlin! Thank you so much for the help! But, could you be more specific? How would you approach this problem?
FILTER ( ALL ( DATA ) ) or FILTER ( ALL ( DATA) , DATA[MONTH] = 1 || DATA[MONTH] = 2 ....?
here's the pseudo code:
var currentmonth = selectedvalue(month)
return calculate(your calculations, filter (all(dates),dates[month]<=currentmonth))
Note: you may need to add a year filter if you have data for more than one year.
now it's worked perfectly!
Many tks!!
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 |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
57 | |
50 | |
44 | |
21 | |
19 |