CODEWITHSUNDEEP
powerbi
funghoul
funghoul

Reputation: 13

Power BI - The total of the columns is not adding up

Im having a problem with Power BI where i put the values in a table but in the total it doesnt show the sum of all the items.

Thats how it's showing in the total of the table:

enter image description here

I tried to adjust with two formulas but it didn't work and it continues to only show the maximum value that was reached :(

first formula:

enter image description here

second:

enter image description here

Does anyone know how I can fix this?

Upvotes: 1

Views: 49

Answers (1)

mkRabbani
mkRabbani

Reputation: 16908

Can you please try a Measure like-

measure=
IF(
    HASONEVALUE(your_table_name[HostName]),
    your MAX calculation here,
    your TOTAL calculation here
)

Upvotes: 1

Related Questions