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
rithu
Frequent Visitor

How to remove a filter using DAX?

I have a column chart x is week and Y is a measure. I have a calculated column to filter and show the last completed week's data. 

Latest Week Check = IF(AND(REPORT[Fiscal Week]<REPORT[Current Week],REPORT[Fiscal Week]>=REPORT[One Week Ago]), "YES", "NO")


Now, I need a tool tip that shows all the historical data removing the last completed week fiter. 

 

I tried writing a new dax for Y axis  to remove the Latest Week Check filter added to the visual using, 

 

Rate All = CALCULATE(CALCULATE(REPORT[measure]), REMOVEFILTERS(REPORT[Latest Week Check]))

But it does not seem to work
I tried ALL and ALLEXCEPT, nothing seems to work. 
What should I do to remove the  Latest Week Check for the tool tip?
2 REPLIES 2
Arul
Super User
Super User

@rithu ,

Did you tried like this?

CALCULATE(CALCULATE(REPORT[measure]), ALL('REPORT')

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


rithu
Frequent Visitor

Hello @Arul 

No, It does not work. The measure is also in the Report table

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.

Top Solution Authors