Forum Discussion
Additional Filter Seems to Nullify Relative Date Filter in Function?
I have a simple measure that calculates a monthly average amount by category using a variable as numerator and a variable as denominator. It works perfectly when set as: Monthly Avg Amount =
VAR ...
Hi Anonymous ,
All function will break filter effect on table, please use allselected function to instead.
In addition, you can take a look at following blog to know more about how to use 'all' function:
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Please understand this link is provided with no warranties or guarantees of content changes, and confers no rights.
Regards,
Xiaoxin Sheng