Forum Discussion

misharaina's avatar
misharaina
Icon for Advocate I rankAdvocate I
4 years ago
Solved

SUMX not working as expected

Hi, I am trying to display the "Row total of vol/mix impact" using sumx but the row total is always displayed as Zero. Out of the multiple versions displayed on the slicer, the user will select two v...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    misharaina , Are you only using Product in visual. If you are using more columns use summarize and add those too

     

    example

    sumx(Addcolumns(Summatize(Fact, Dim[Col1], Dim2[Col2]), "_1",[Measure]) , [_1])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

misharaina , Are you only using Product in visual. If you are using more columns use summarize and add those too

 

example

sumx(Addcolumns(Summatize(Fact, Dim[Col1], Dim2[Col2]), "_1",[Measure]) , [_1])