Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Why doesn't REMOVEFILTERS work?

I have a simple formula that calculates the incident count per month, which is then broken down by our defined week of the month (all months have W1, W2, W3, & W4).  Works great.   Avg Count per m...
Reports
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous ,

Try using ALL in the following manner:

CALCULATE('Incident Measures'[_Inc Count] / [_Count of Months], ALL('DATE Table'))


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/