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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
powerbi56
Frequent Visitor

How do I not get the slicer to affect the table?

Hi, this may be a simple issue but I'm unable to figure it out.

 

I have a table- 

powerbi56_0-1715035546121.png

I have made it by using the percent of column total because I need to see the percent of the each result per month. The values do not change when I use the date slicer. But it does change to 100% when I have the Last result PGS slicer- since I click it, that is the total column assuming that's why it shows up as 100%. How do I still use the slicer but keep these orginal numbers?

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@powerbi56 , Assuming you are using a date table for month and year, you can have measure like

 

divide([Measure], calculate([measure], filter(all(Date), Date[Year] = max(Date[Year]) && Date[Month] = max(Date[Month]) )) )

 

or

 

divide([Measure], calculate([measure], removefilters(Table[Last result PGS]) ) )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Anonymous
Not applicable

Thanks for the reply from @amitchandak , please allow me to provide another insight: 
Hi  @powerbi56 ,

 

You can use the measure+all() function instead:

All(): returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.

Refer to:

ALL function (DAX) - DAX | Microsoft Learn

 

 

Measure =
var _sum=
SUMX(
    FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])&&'Table'[Month]=MAX('Table'[Month])),[Value])
return
DIVIDE(
    SUM('Table'[Value]),_sum)

 

 

vyangliumsft_0-1715046475580.png

 

Best Regards,

Liu Yang

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks for the reply from @amitchandak , please allow me to provide another insight: 
Hi  @powerbi56 ,

 

You can use the measure+all() function instead:

All(): returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.

Refer to:

ALL function (DAX) - DAX | Microsoft Learn

 

 

Measure =
var _sum=
SUMX(
    FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])&&'Table'[Month]=MAX('Table'[Month])),[Value])
return
DIVIDE(
    SUM('Table'[Value]),_sum)

 

 

vyangliumsft_0-1715046475580.png

 

Best Regards,

Liu Yang

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

amitchandak
Super User
Super User

@powerbi56 , Assuming you are using a date table for month and year, you can have measure like

 

divide([Measure], calculate([measure], filter(all(Date), Date[Year] = max(Date[Year]) && Date[Month] = max(Date[Month]) )) )

 

or

 

divide([Measure], calculate([measure], removefilters(Table[Last result PGS]) ) )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors