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
Icon for Community Champion rankCommunity 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

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