Not getting Total Amount for all years while selecting "Select All" in slicer.

[jay_patel]

Hello All

As shown in 1st Screenshot, I have selected 2018 and there is value for the selected year and same for 2019 & 2020 and for 2021 there is Blank Value. But the problem is when I am selecting All years it's giving "Blank" instead of giving sum for all years.

Thanks in advance guys !

[v-stephen-msft]

Hi @jay_patel ,

Are you using SELECTEDVALUE()? If it is, select all will not work. You can check my demo from the attachment.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi, @jay_patel 

Please share your sample pbix file's link here, then I can try to have a look into it to come up with a suitable solution.

Thank you.

[jay_patel]

Thanks @Jihwan_Kim 

I got the solution for the same issue.