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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
arielcedola
Helper III
Helper III

Measure that needs the maximum value in a column, but disabling all interactions with the report

Hi, I need to create a measure that must use the maximum value in a column to perform a calculation. This maximum value, however, must keep unchanged even when in the page of the report there are several slicers that affect the determination of it.

Is there any way of disabling the interaction between the measure and all objects in the report? For instance, is it possible to create a variable that remain always unchanged?

I have done some tests by disabling the interaction between visual objects, but I'd need to manage this inside the DAX formula.

Thanks.

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

ALL remove all filter context.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

ALL remove all filter context.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

I already tried, but it didn't work:

 

Measure = CALCULATE(MAX('Table'[Column]); ALL('Table'[Column]))

 

But I realize now that I was using ALL in a wrong way: introducing the full Table as its argument works well.

 

Thanks.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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