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

Re: SUM TOTAL MEASURE VALUES

You can display this information in a card.

mdelasheras 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

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

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?

v-jiascu-msft 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 Top Kudoed Authors
Users Online
Currently online: 340 members 3,504 guests
Recent signins:
• pankshen • JeroenAcumen • FaaZ444 • fg1992 • jama1234 • alanmortellaro • D_PBI • KellyHewitt • alanwilliams2 • katherine33 • BettyK • ammarsn72 • lhanna12 • svilaseca 