I need a Measure that adds up the total of a column of a Table viewer object

[Syndicate_Admin]

Hello, thank goodness there is this forum, I am a beginner and without your answers I would be very lost.

I'm stuck on the following:

I have 3 what if from three cities where manually the user types the number of inhabitants of each city, these amounts are dumped into a table visual. Apart from these amounts I have added another measure where it is calculated, on the amounts that have been manually put 8% more. My problem is that this table does not add up the totals, nor those that are entered manually nor the column that I have added, and I need measurements that calculate the totals. Please Could you help me?

I put the two measures I have and a screen print so that you have the maximum information:

Measure of Number of Inhabitants:

Number of Inhabitants =

Switch(true() ,

Max('Ciudades-Valores Pant'[Ciudades])="MADRID",SelectMadrid[Valor Madrid],
Max('Ciudades-Valores Pant'[Ciudades])="BARCELONA",SelectBarcelona[Valor Barcelona],
Max('Ciudades-Valores Pant'[Ciudades])="SEVILLA",'SelectSevilla'[Valor SEVILLA],
BLANK()
)

Measure Population inhabitants 8%+

Estimated population 8% =

sum('Digital Table Habit and Cities'[Number of Inhabitants])*(1+0.08%)

)

And as always thank you very much for your help

Greetings

[v-jingzhang · Accepted solution]

Hi @JaviBI 

You can try these measures

Number of Inhabitants = 
SWITCH(TRUE() ,
SELECTEDVALUE('Ciudades-Valores Pant'[Ciudades])="MADRID",[MADRID Value],
SELECTEDVALUE('Ciudades-Valores Pant'[Ciudades])="BARCELONA",[BARCELONA Value],
SELECTEDVALUE('Ciudades-Valores Pant'[Ciudades])="SEVILLA",[SEVILLA Value],
[MADRID Value]+[BARCELONA Value]+[SEVILLA Value]
)

Estimated population 8% = [Number of Inhabitants] * (1+0.08)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Syndicate_Admin , Try a measure like

Estimated population 8% =

sumX(Values('Ciudades-Valores Pant'[Ciudades]),('Digital Table Habit and Cities'[Number of Inhabitants])*(1+0.08%))

[Syndicate_Admin]

Hello, at first I saw the structure and I thought it was fine, but when it comes to applying it in the power bi report I am not able to adapt it. I tell you, I do not know where the measure of "Values" comes from, in my explanation there is nothing about it. the values of the cities come from the What if parameters.