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.
I have a data set with counts per number of weeks before a certain date. I want to visualsie this as a running total.
I'm using this as my measure:-
My result is only partially correct, it looks like the picture below. The problem is the currently selected data (from slicers) contains no records for weeks 29 to 52 but these week numbers exist for rows that are filtered out by the slicer. This seems to be causing an error in the calculation. What am I missing?
Solved! Go to Solution.
It is working correctly. When you use ALLSELECTED in your measure, it only returns values that are available to the current visual. Since you have filtered data from weeks 29-52 via slicer, the data isn't used.
You can try replacing ALLSELECTED with ALL or ALLEXCEPT, though you may have to reapply other filters as necessary.
tickets running total in weeks_before 2 = CALCULATE( SUM('sales_over_time (2)'[tickets]), FILTER( ALLEXCEPT('sales_over_time (2)', 'sales_over_time (2)'[weeks_before]), ISONORAFTER('sales_over_time (2)'[weeks_before], MAX('sales_over_time (2)'[weeks_before]), ASC) ) )
Hi @davegw ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
It is working correctly. When you use ALLSELECTED in your measure, it only returns values that are available to the current visual. Since you have filtered data from weeks 29-52 via slicer, the data isn't used.
You can try replacing ALLSELECTED with ALL or ALLEXCEPT, though you may have to reapply other filters as necessary.
tickets running total in weeks_before 2 = CALCULATE( SUM('sales_over_time (2)'[tickets]), FILTER( ALLEXCEPT('sales_over_time (2)', 'sales_over_time (2)'[weeks_before]), ISONORAFTER('sales_over_time (2)'[weeks_before], MAX('sales_over_time (2)'[weeks_before]), ASC) ) )
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |