Forum Discussion
Incorrect TOTAL in Table
Hi
I am working on a PBI graph table but I am having a problem with the total in one column:
In order to get the values in the "Test" column I have a metric that is showing the correct values by MODALIDAD:
Test =
DIVIDE( SUM(VW_OUTB_SLAs[PIEZASv])*SUM(VW_OUTB_SLAs[PONDERACION]),
CALCULATE (
SUM (VW_OUTB_SLAs[PIEZASv] ),
ALLSELECTED ( VW_OUTB_SLAs[MODALIDAD] )
)
)
the metric is basically: (Suma Ponderacion Column * Total Piezas Column) / TOTAL AMOUNT OF Total Piezas Column)
so the total amount of the column test should be 9.38 and not 45.75
so the total amount of the column test should be 9.38 and not 45.75
Hi,
Try this measure
Measure = SUMX(VALUES(VW_OUTB_SLAs[MODALIDAD]),[Test])
Hope this helps.
1 Reply
Hi,
Try this measure
Measure = SUMX(VALUES(VW_OUTB_SLAs[MODALIDAD]),[Test])
Hope this helps.