Forum Discussion
Saving Filters as Measures
Hi Anonymous ,
As FILTER function returns a table, so you cannot save it as a measure or column, but you can save it as a new table to solve your issue, like this:
1.Create a new table.
2.Create relationship.
3.Directly use the new table as a filter in your DAX.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
You don't need to use the filter. You can directly use the column within CALCULATE() without using FILTER().
MyExpression =
CALCUALTE( SUM( table[column] ), table[column1] = "Condition" )
I could, but this doesn't really solve the issue of re-writing the conditional statement over and over again.
It would be nice if I could change this in one place (like you can with a measure). Something like:
myFilter = FITLER(table,table[column]="condition")
To ultimately use the filter in multiple measures like this:
measure1 = CALCULATE(SUM(table[column]),myFilter))
measure2 = CALCULATE(SUM(table[column1]),myFilter))