I'm writing to getsome help on my current issue. I built a model to calculate some price variation impacts.
I have a measure to get this (basically multiplying price variation by qty for each material ref sold). It's working well at row level & I can filter/drilldown/analyze at different level.
Now I would like to show the total impact instead of having to look all rows. The problem is that as it is a measure, the total is calculated using the formula. What I want is to show the total of all rows.
I first think of creating a calculated column instead of formulas but that does not work as I need the calculation by row to be done depending on my filters. So row calculation has to be dynamic (=measure).
Do you know how I can "force" a measure to give total of rows & not just applying the formula on total ?
Not sure I'm clear but I still hope someone may have face the same issue & can help.