Forum Discussion
Solved
PowerBI Wrong Total Sum calculation
Hello PowerBI Community, I have recently started using PowerBI and came across an issue in a report. I am trying to present in a table the amount of working hours per "OA ID" (with "Customer" (w...
Think this should do it
SUMX(
VALUES( VW_ACTUALS_OPERATI[OA_ID] ),
VW_ACTUALS_ACT[OPT hours]
)
Hi,
I have encountered a similar problem before.
You can make a workaround by creating a new column in your W_ACTUALS_ACT dataset.
Say label them as "1" and else is "0". This is just to group those ids that are in the VW_ACTUALS_OPERAT.
Example is using (if OA-ID in VW_ACTUALS_OPERAT = OA_ID in W_ACTUALS_ACT then 1 else 0)
You can then use that column in your Table Visual to filter those that has "1" value.