cancel
Showing results for
Did you mean:
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.

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?

5 REPLIES 5
Member

## Re: SUM TOTAL MEASURE VALUES

You can display this information in a card.

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?

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.
Regular Visitor

## Re: SUM TOTAL MEASURE VALUES

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?

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.

Announcements

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### 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.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 340 members 3,504 guests
Recent signins: