Forum Discussion

k63's avatar
k63
Frequent Visitor
2 years ago

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

6 Replies

  • Based on my experience, there should be no solution to achieve this idea.

  • please share sample data with some more axis you like to switch. will try

    • k63's avatar
      k63
      Frequent Visitor

       Hi, how can i share you my pbi example ? 

      PBI files upload is not supported here

      • Rupak_bi's avatar
        Rupak_bi
        Icon for Super User rankSuper User

        You can paste sample data here in reply with all possible axis variability.