I want to add a column or measue that would do the same as the excel function:
sumifs(Net tons PY, [Column] Article,[Row in column Article] article number, [Column] Workcenter, [Row in colum workcenter] Workcenter).
Summarized: i need the tons based on the criteria that its suppose to be in de same article & workcenter.
I have been using DAX since a couple of weeks, so untill now i only know the SUM & DIVIDE function. I tried working with CALCULATE but was not able to get it working.
Does anyone know how i can make this work?
sumifs(Net tons PY, [Column] Article,[Row in column Article] article number, [Column] Workcenter, [Row in colum workcenter] Workcenter).
Summarized: i need the tons based on the criteria that its suppose to be in de same article & workcenter.
I have been using DAX since a couple of weeks, so untill now i only know the SUM & DIVIDE function. I tried working with CALCULATE but was not able to get it working.
Does anyone know how i can make this work?