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])

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

Hi Amit,

 

I am using a parameter.

So my code is - 

RETURN SWITCH(SELECTEDVALUE('Metric (Support)'[Select Metric]),
"Revenue ($M)", Result/10^6,
IF (HASONEVALUE('Parameter Table'[Fields]),result,
Sumx('Parameter', Result)))

Best

Misha