Forum Discussion

mmanwaring's avatar
mmanwaring
Resolver 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
Super 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
Resolver I
4 years ago

Hi amitchandak

 

----


Thank you Mike

    • mmanwaring's avatar
      mmanwaring
      Resolver I
      4 years ago

      Hello

      Sorry try now  sample 

       

      thank you

      Mike

    • mmanwaring's avatar
      mmanwaring
      Resolver I
      4 years ago

      Hi

      The measure works fine until i add the filter for the movement types then it breaks. It will be ok if i make a new table but not if i calculate a new table within the measure?

      Thanks Mike