How can I use Cards without aggregation ?

[ahmetturetmis]

Hi all,

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 =
    SUMX(
        SUMMARIZE(
            ALLOWED_ACTIVITIES,
            ALLOWED_ACTIVITIES[ProjectCode],
            ALLOWED_ACTIVITIES[Discipline],
            ALLOWED_ACTIVITIES[SubDiscipline],
            ALLOWED_ACTIVITIES[Activity],
            "Total",
                SUM( ALLOWED_ACTIVITIES[Planned Qty] )
                    * SUM( ALLOWED_ACTIVITIES[ClientActPms] )
                    * SUM( ALLOWED_ACTIVITIES[ClientSubdiscPms] )
                    * SUM( ALLOWED_ACTIVITIES[ClientDiscPms] )
        ),
        [Total]
    )
RETURN
    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. 

[Anonymous]

Hi @ahmetturetmis ,

Is there only ProjectCode412 in the table? Can you share some sample data to us?

Best Regards,

Jay

[ahmetturetmis]

Actually no, I just use a filter not to show all projects. I need a card where it only shows %16.50 instead of %16.48 when a project is selected from filter.

[Anonymous]

Hi @ahmetturetmis ,

It's better to share some sample data so that we can check your formula. For measure, the total is not the sum of the measure values. It's a calculated value obtained by formula too.

Best Regards,

Jay