SUMX(FILTER( ?? filter by using slicer

[Anonymous]

Hello,

I have a multi select slicer on my report, and I would like to create a measure for by using slicer.

I have a [sales plan] and [sales result] table.

Both tables have a [date] and [amount].

If 2021/4 and 2021/5 is selected in my slicer, I would like to have a sum of

2021/4/1 to 2021/5/31 Sales Result and

2021/6/1 to 2022/3/31 Sales plan.

If only 2021/5 is selected, I would like to I would like to have a sum of

2021/5/1 to 2021/5/31 Sales Result

and 2021/4/1 to 2022/4/30 and 2021/6/1 to 2022/3/31 Sales plan.

I was trying to use SUMX(FILTER(

Could someone help me.

[V-pazhen-msft]

@Anonymous 
There are typos make confusion, better just share a sample pbix, and show your expected output.

Paul Zheng _ Community Support Team

[MFelix]

Hi @Anonymous ,

This can be done using the SUMX and a disconnected table for your slicer however without data and how your model is setup is difficutl to pinpoint the calculation especially since you want to have the years ahead.

Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.