Forum Discussion
Solved
Get correct subtotal in simple measures
Good morning, I am trying to calculate a simple measure subtotal, but I am having problems doing so. I have the following simple table: I am trying to calculate the POND 1 and POND...
mizaskun , Create a measure like
sumx(summarize(Table, Table[persona], table[Region], Table[RIEGO], "_1",[P1]*[P2]) , [_1])
mizaskun , Create a measure like
sumx(summarize(Table, Table[persona], table[Region], Table[RIEGO], "_1",[P1]*[P2]) , [_1])
It works! Great! Thank you!
I need to calculate now the sum of the different P% that we have just calculated with your formula * the VAL field. I am trying something like:
TOTAL = PRUEBA[P%]*sum(PRUEBA[VAL]), but it sums 11. How could I get the correct value?
Thank you so much!