Sum rows dynamically filtered by date

[lucabalbi]

I have a PowerBI report with many date on the same fact tables join with a unique date table. I would like sum rows during filtering applied on Date table on report.

On the picture:

• I would like that data on the red box change dynamically when years filter is applied

[Anonymous · Accepted solution]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[v-anabat]

Hi,

Please provide some sample data in either text/table format along with the sinppet. A snippet doesn't allow users to readily copy the data and do a quick test. This reduces chance of your question getting answered.

Regards,

Ananth