Forum Discussion
k63
2 years agoFrequent Visitor
How to SumX over dynamic axis ?
Hello,
I'd like to create a measure that performs a SumX of an indicator according to the axes I put in my table, for example :
Here the MixEffectSumX measurement is good, the total is the expected number
But here the measurement only works for a specific axis (Item_Category)
My DAX formula : MixEffectSumX = SUMX(VALUES(Article[Item_Category]), [MixEffect])
The idea is that I would like to replace VALUES(Article[Item_Category]) with something that contains all the axes that I put in my table dynamically. Bearing in mind that I have ten or so dimensions and a hundred or so possible axes, the idea is that if I ever add axes in the future, I won't be obliged to modify this measure.
Does anyone have any clues?
Thanks in advance