The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am unable to include Page level filters in the DAX Measure that calculates cumulative total for each year.
Hi @Hoping ,
Please share a sample file with us and show us a screenshot with the result you want. This will make it easier for us to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think your measure is right there is minor mistake in measure 2 you have not written (New) in filter condition.
So, it will confuse during the condition checking.
If above will giving the error then try this:
User | Count |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
6 | |
6 |