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 need help with a similar problem on the link below.
The solution was indeed correct just had to change it a bit
Running Total = CALCULATE ( SUM ( 'Table1'[Count] ), FILTER ( ALLSELECTED ( 'Table1' ), 'Table1'[Date] <= MAX ( 'Table1[Date] ) && 'Table1'[Client] = MAX ( 'Table1'[Client] ) ) )
the result was correct only if the selected date slicer is between 31 days. If the filter exceeded 31 days it would add august month and september month's day.
HI @ggzmorsh ,
Do you mean add next/previous date period records(slicer selection date range) to current summarized data bar?
I think it is hard to achieve your requirement, you need to write measure formula with if statement to check current row contents and ignore calculation on 'uncompleted date period' and summarize them to previous data period.
Otherwise, these records will summarize based on current row contents group and filtered by current axis group.(year month)
Row Context and Filter Context in DAX
Notice: if you are confused on coding formula, please share some sample data and expected result for test.
Regards,
Xiaoxin Sheng
Here is my pbix file. On the Project page contains the comulative data for the race bar chart.
If you select Aug1 to Aug31 on the date slicer it will give you the correct data. If you select Aug1 to Sep10 it will add Aug1-Aug10 and Sep1-Sep10 in the first 10 days of the bar chart.
https://drive.google.com/open?id=1fxtbvSZD-BzHnSjITCb3BnbGnGZ5KTmg
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |