I am calculating some completion percentages for some projects depend on some weights of activities.
My measure is working in a matrix or a table but when I try it in the card it shows wrong amounts.
Truncated Measure for Card is
Completion Client CARD =
VAR SubPMS =
IF( ISBLANK( [Client SubDis PMS] ), 1, [Client SubDis PMS] )
VAR DisPMS =
IF( ISBLANK( [Client Dis PMS] ), 1, [Client Dis PMS] )
VAR solo =
SUMX( ALLOWED_ACTIVITIES, [Actual QTY] * [Client Act PMS] * SubPMS * DisPMS )
VAR total =
SUM( ALLOWED_ACTIVITIES[Planned Qty] )
* SUM( ALLOWED_ACTIVITIES[ClientActPms] )
* SUM( ALLOWED_ACTIVITIES[ClientSubdiscPms] )
* SUM( ALLOWED_ACTIVITIES[ClientDiscPms] )
DIVIDE( solo, total, 0 )
and the I select a project from the filter. table looks like that
I would like to see 16.50 % but Card shows a wrong aggregated value as 16.48 %
What should I do to get the 16.50 % when someone select 412 from the project filter ?
Thanks in advance.