Forum Discussion

rithu's avatar
rithu
Frequent Visitor
3 years ago

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 ...
Get Help
Arul's avatar
Arul
Super User
3 years ago

rithu ,

Did you tried like this?

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

Thanks,

Arul

rithu's avatar
rithu
Frequent Visitor
3 years ago

Hello Arul 

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