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('Put Away lines','Put Away lines'[Quantity])

 

Shipped Take Returned = 'Shipment Lines'[Total Number Shipped] - 'Put Away lines'[Number of Returned Boards]

 

Total Number Shipped = SUM('Shipment Lines'[Quantity])

 

In my Bar chart if i filter for a specific value (Item) in this case this shows the correct figure.


However with no filter ( All items) the value is taking a sum of the average im guessing im not too sure.

Can anyone guide me on how to resiolve this. Thanks

Need Help

5 Replies

  • 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