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.
https://www.dropbox.com/s/3jhxh8ho8791dxi/Cumulative%20Values%20Line%20Chart.pbix?dl=0
When i hide/filter out previous quarters I loose the correct cumulative value for the shown quarters.
How to deselect certain quarters without affecting the cumulative amount in the selected ones.
In the example my goal is to show 2017 Q2 up until 2018 Q4 Quarters only
Solved! Go to Solution.
Hi @sjoerdbuis ,
Please try this measure:
Amount running total in Year-Quarter2 = CALCULATE( SUM('Transacties'[Amount]), FILTER( ALL('Date'[Year-Quarter]), ISONORAFTER('Date'[Year-Quarter], MAX('Date'[Year-Quarter]), DESC) ) )
Best regards,
Yuliana Gu
Hi @sjoerdbuis ,
Please try this measure:
Amount running total in Year-Quarter2 = CALCULATE( SUM('Transacties'[Amount]), FILTER( ALL('Date'[Year-Quarter]), ISONORAFTER('Date'[Year-Quarter], MAX('Date'[Year-Quarter]), DESC) ) )
Best regards,
Yuliana Gu
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
56 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |