Forum Discussion

ahmetturetmis's avatar
ahmetturetmis
Frequent Visitor
5 years ago

How can I use Cards without aggregation ?

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. 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ahmetturetmis ,

     

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

     

    Best Regards,

    Jay

    • ahmetturetmis's avatar
      ahmetturetmis
      Frequent Visitor

      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's avatar
        Anonymous
        Not applicable

        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