Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

 

1. Can you explain what you are trying to do for the "Sales" option in the SWITCH?

2. What exactly are you trying to do with

       FILTER ( PivotedData, PivotedData[Attribute Value])

3. Can you show your data model or share the pbix? Otherwise it's kinda hard to guess what might be going on