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 Community.
Solved! Go to Solution.
I just went to the model and I don't know how but the cumulative works as it should.
A great mystery to me.
Thank you guys, really appreciate the efforts and the time 😊
I just went to the model and I don't know how but the cumulative works as it should.
A great mystery to me.
Thank you guys, really appreciate the efforts and the time 😊
Hello again,
I am very thankful to your interest in my issue, and I have a question regarding this.
Is it a matter on how Power BI prioritize the filters?
I just tested drilling down from an account, who has a balance at the end of selected month and year, but has no transaction in the same period.
Normal sum = blank [Sure there are no transaction in the selected period]
Cumulative = blank [which is my issue]
All = gives me a total [which is all transaction in the selected period only all data, not all dates and all data, therefore the ALL(Calendar) is not working after drilling]
Once I clear Month or Year filter the data comes as anticipated.
Hop this test be useful in any way.
@ahmadhatahet , share Normal sum and Cumulative formula
Thank you for your reply.
Hi @ahmadhatahet ,
What is the relationship between your fact table and calendar table ?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you for your reply.
Calendar > Data (1 > *) [Date column as a key]
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 | |
100 | |
86 | |
64 |