cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mdelasheras Regular Visitor
Regular Visitor

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.

 SUMTOTAL.png

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

5 REPLIES 5
BKirsch12 Member
Member

Re: SUM TOTAL MEASURE VALUES

You can display this information in a card.

mdelasheras Regular Visitor
Regular Visitor

Re: SUM TOTAL MEASURE VALUES

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

v-jiascu-msft Super Contributor
Super Contributor

Re: SUM TOTAL MEASURE VALUES

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mdelasheras Regular Visitor
Regular Visitor

Re: SUM TOTAL MEASURE VALUES

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:

 

 

sumx.png

Do you need an extended sample?

v-jiascu-msft Super Contributor
Super Contributor

Re: SUM TOTAL MEASURE VALUES

Hi @mdelasheras,

 

It would be better to have a full sample.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 340 members 3,504 guests
Please welcome our newest community members: