Pivot

[PSRai]

Hi 

I am getting a issue where by my totals are not adding up correctly

I have a pivot table the column subtotals are brining back in incorrect figure.  it seems to be the column subtotal is total across all date ranges rather than the one specified.

The individual readings are correct and the and row subtotals are correct?

[PSRai]

Hi,

My table is a direct query from Google big query. In the table I have column that has energy readings, date-time and socket id amongst others.

I have created 3 columns based on the energy column, 1 is MAX energy, 2 MIN energy and 3 MAX-(Minus) MIN.

When I pivot MAX minus MIN it should be the total of the row difference and not what I am seeing in the total column.

I should see 27.91 and not 516

• 

[Anonymous]

still hard to see exactly, but what if you wrap your function like:

SUMX(
    VALUES( table [col] that is on rows),
    [Measure]
)

[PSRai]

Hi,

Im still getting the same result. 

I have a electric board that has 20 sockets, I need to work out the energy used within each hour period per socket. Individually for each socket the MAX - (minus) - MIN energy that I created works correctly. When I use MAX - MIN as a total of all sockets its basically bringing back a figure of 516 rather than 27.9. In my raw data there are instances where energy MIN is 0 and MAX 516. 

in my pivot table the individual socket readings are correct but total is not the sum of all readings

for e.g.

1          2        3        4        5         6

0.12    0.0    0.03    0.14   0.00    0.07    = 0.36, however what Im seeing is 516

[Anonymous]

they arent "wrong" they are just not what you expected. Any chance you can upload the pbix or the at least the function?