Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculation sumX multiplication

Hello; i'm performing my calculation with the sumX function, in a simplified way, my code has the following form: measure=sumx(A)*sumx(B)*sumx(C) i'm getting the results as ( A1 + A2 + A3 ...)*(B1...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Here is a sample file with the solution https://www.dropbox.com/t/obELBigMGJIPqhHd

    Actually I have tried the same solutions and they seem to work. The thing is it won't allow me to create the hierarchy slicer with pop-up a message saying that the relationship should be One - Many. I don't know how did you create it but arbitrarily shaped slicers usually causes trouble. Using them would require the use of KEEPFILTERS. Unfortunately I failed to simulated your case but you can refer to (2) When to use KEEPFILTERS over iterators - YouTube

    Following two workable solutions but using normal slicers.

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 
Still not 100% clear but you may try

Measure1 =
SUMX ( Table1, SUMX ( Table2, Table1[A] * Table1[B] * Table2[C] ) )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

no still doesn't work, this formula gives me:
(C1+C2)*A1*B1 + (C1+C2)*A2*B2 (if i'm working with 2 values)

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 
    Ok. Then please try

    Measure1 =
SUMX ( Table1, Table1[A] * Table1[B] * SUM ( Table2[C] ) )
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      it gives the same value as the previous one

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Anonymous 

        Measure1 =
SUMX ( Table1, Table1[A] * Table1[B] * CALCULATE ( SUM ( Table2[C] ) ) )