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
Anonymous's avatar
Anonymous
Not applicable
7 years ago
I have added a picture to help
AlB's avatar
AlB
Community Champion
7 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    This is my code for the KPI field not LastYearKPI KPI = if([Attribute Filtered], SWITCH( [rankBy] ,"QUS",FORMAT(CALCULATE(sum(MK_PAPA_WEEKLY_PRODUCT_CARE_REPORTING[QUS]),FILTER(PivotedData,PivotedData[Attribute Value])), "#,0") ,"QUS Sales", FORMAT(CALCULATE(sum(MK_PAPA_WEEKLY_PRODUCT_CARE_REPORTING[QUS Sales]),FILTER(PivotedData,PivotedData[Attribute Value])), "£#,##0;(£#,##0)") ,blank())) This works absolutely fine and when you select a slicer of the PivotedData[Attribute Value] it filters the figure by this. I just need it so this works year on year. I can't work out how to put my code in code format in a comment