Forum Discussion

LewisH's avatar
LewisH
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper II
8 years ago

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