Forum Discussion
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 + B2 + B3 ...)*(C1 + C2 + C3 ...)
What should i do in order to have my calculation performed in the following form:
(A1*B1*C1) + (A2*B2*C2) + (A3*B3*C3) + ... ?
Hi Anonymous
Here is a sample file with the solution https://www.dropbox.com/t/obELBigMGJIPqhHdActually 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.
19 Replies
Follow this pattern = SUMX( Table, Table[ColA] * Table[ColB] * Table[ColC] )Hi Anonymous
are they in the same table or different tables?Anonymous
Do they have 1:1 relationships? I mean how do you know which row to multply with which row? As you mentioned (A1*B1*C1) + (A2*B2*C2) + (A3*B3*C3) + ... or do you mean (A1*B1*C1) + (A1*B1*C2) + (A1*B1*C3) + ... ?
Hi Anonymous
Here is a sample file with the solution https://www.dropbox.com/t/obELBigMGJIPqhHdActually 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.
