Forum Discussion

mmanwaring's avatar
mmanwaring
Icon for Resolver I rankResolver I
4 years ago

Filter context breaking my calculation

Hi All, Hope someone can shed some light on my problem. I have a stock movement calculation which is pivoted by col = sku and row= year. The problem is that the table has to be filtered to the cor...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mmanwaring , Try like

CALCULATE(SUM(MovementsInOut[TrueQuantity]), FILTER( MovementsInOut , movementsInOut[movementtype] IN {100,392,227,235,225}), filter(all(DimDates) ,DimDates[Date] <= MaxDate ))

  • mmanwaring's avatar
    mmanwaring
    Icon for Resolver I rankResolver I
    4 years ago

    Hi, Thank you for your reply.
    It does however not change the results.
    Mike

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      mmanwaring ,
      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

      • mmanwaring's avatar
        mmanwaring
        Icon for Resolver I rankResolver I
        4 years ago

        Hi amitchandak

         

        ----


        Thank you Mike