Forum Discussion

LewisH's avatar
LewisH
Helper II
8 years ago

Measure is changing based on filters

I have a graph which is based on a date and this measure  Yield = ('Put Away lines'[Number of Returned Boards] / 'Put Away lines'[Shipped Take Returned]) * 100   Number of Returned Boards = SUMX('...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI LewisH,

 

I think you formula works properly, when you use sum or other functions, it will auto summary by group label or column and also affected by filter/slicer.

 

For your requirement, you need to add some conditions to filter table to let your formula only work on current row contents instead all table.

 

Regards,

Xiaoxin Sheng

LewisH's avatar
LewisH
Helper II
8 years ago

Hi do you have any suggestions on how I can do this? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI LewisH,

     

    >>Hi do you have any suggestions on how I can do this? 

    Please share some sample data or pbix file to test.

     

    Regards,

    Xiaoxin Sheng

    • LewisH's avatar
      LewisH
      Helper II
      8 years ago

      How can I share my pbix file with you?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI LewisH,

         

        Upload to onedrive or google drive and share the link here.
        Notice: please do mask on sensitive data before share.

         

        Regards,

        Xiaoxin Sheng