Forum Discussion

mdelasheras's avatar
mdelasheras
Helper I
8 years ago

SUM TOTAL MEASURE VALUES

Hi all,

 

I want to display the sum of a measure but Power BI applies the measure in the total ROW. How can i change it??

There is an example table where TOTAL SUM should be 61 instead of 45.

 

Current measure is : 

% RV = IF([%Global] >= 1,2;1,2*SUM('Merge2'[Peso]);(IF([%Global] >= 1;SUM('Merge2'[Peso]);(IF([%Global] > 0,9;0,5*SUM('Merge2'[Peso]);BLANK())))))

Any tip?

Thanks in advance

Need Help

5 Replies

    • mdelasheras's avatar
      mdelasheras
      Helper I
      8 years ago

      I would like to show the sum in this table, there is no way to make it work as intended? 

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi mdelasheras,

         

        Can you share a sample? The "Total" has different contexts. The solution could be as follows.

        Measure =
SUMX (
    SUMMARIZE (
        'table';
        'table'[column];
        "value"; IF (
            [%Global] >= 1,2;
            1,2 * SUM ( 'Merge2'[Peso] );
            (
                IF (
                    [%Global] >= 1;
                    SUM ( 'Merge2'[Peso] );
                    (
                        IF ( [%Global] > 0,9; 0,5 * SUM ( 'Merge2'[Peso] ); BLANK () )
                    )
                )
            )
        )
    );
    [value]
)

        Best Regards,

        Dale