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.   ...
Need Help
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

mdelasheras's avatar
mdelasheras
Helper I
8 years ago

Hi v-jiascu-msft,

 

I tried your measure but im not getting the value im looking for, what i need is to sum the last column ( 5 + 5 + 18 + 10 + 18 +5). With this measure I'm getting a value i don't understand:

 

 

Do you need an extended sample?

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

    Hi mdelasheras,

     

    It would be better to have a full sample.

     

    Best Regards,

    Dale