Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jay_patel
Helper IV
Helper IV

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

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.

 

Screenshot (48).pngScreenshot (49).png

 

Thanks in advance guys !

 

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @jay_patel ,

 

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

Screenshot 2021-04-23 164717.png

 

 

 

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
Super User
Super User

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Thanks @Jihwan_Kim 

 

I got the solution for the same issue.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.