topic Sum rows dynamically filtered by date in DAX Commands and Tips

Sum rows dynamically filtered by date

lucabalbi — Wed, 28 Aug 2019 10:36:49 GMT

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

Re: Sum rows dynamically filtered by date

v-anabat — Wed, 28 Aug 2019 10:52:47 GMT

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

Re: Sum rows dynamically filtered by date

Anonymous — Wed, 28 Aug 2019 11:35:36 GMT

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