Measure is changing based on filters

[LewisH]

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

[Anonymous]

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]

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

[Anonymous]

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]

How can I share my pbix file with you?

[Anonymous]

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