Forum Discussion
DAX - Filtering not working
I have a dax formula that looks at the previous year's data of difference values. I have a slicer which I can choose between Units and Sales. LastYearKPI = if([Attribute Filtered],
SWITC...
Anonymous,
It seems that you'll need to add <value>.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
I have added a picture to help
Anonymous
If I'm not mistaken
FILTER(PivotedData,PivotedData[Attribute Value])
will eliminate only rows for which [Attribute Value] is zero or blank( ). Do we agree?
Is that what you want to do?