REMOVEFILTERS not working in Calculate

[julian_malisano]

Hello All,

I'm working through the PL-300 labs for Power BI and have encountered an issue using the REMOVEFILTERS function in CALCULATE. The context doesn't seem to evaluate properly. Link to lab

According to the lab, this expression:

Sales All Region =  CALCULATE(SUM(Sales[Sales]), REMOVEFILTERS(Region))

Should evaluate to:

However, when using the exact same formula, I get:

Any ideas?

[daXtreme]

I can't see anything wrong with this... You have not noticed that the formats of Sum of Sales and Sum Of Sales All Region are different but they are in fact the same numbers. What's more, it really does matter where you take your columns from. It's not that you can drop any column from any table (when they have the same names) and expect the report to calculate the same. No, it does not work like that. Also measures are sensitive to which columns you use in them and which you put on the canvas...

Please remember one golden rule of dimensional modeling: You should never use columns from fact tables on your canvas. Only slicing by dimensions is allowed.

[julian_malisano · Accepted solution]

Thanks for the pointers! Turns out it wasn't data model related, but a mega-rookie mistake. Somehow I had selected a Calculated Column rather than a Measure to write the DAX!...