Solved: Re: Retain Measure level with Slicer added?

Anonymous · ‎05-23-2022

Hello,

Please see the 2 screenshots below (first without the slicer, what I want to see, the 2nd with the slicer, that changes the cummulative percent totals, what I don't want to see).

Is there a way I can retain the 'percent_all' amount, grouped by 'resolution' and 'specialty', even when the slicer is selected?

Thx!!

WHAT I WANT TO SEE with percentages

What I don't want to see (with slicer applied)

amitchandak · ‎05-23-2022

@Anonymous , use ALL in place of ALLSELECTED

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎05-23-2022

@Anonymous , use ALL in place of ALLSELECTED

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Anonymous · ‎05-24-2022

Works!! Thank you!!!

Retain Measure level with Slicer added?

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly