Quick Measure showing totals when column values are zero

Anonymous — Mon, 11 Jul 2022 18:56:41 GMT

Hello!

I have a PowerBI table where I added a quick divide measure to get me the Annual Rent per anima type, the caluclation on the rows is correct, but the total at the bottom of the table shows a figure when the entire column is supposed to be 0.

Location	Animal Type	Count of Animal Type	Grant Total of All Animal Types for location	Annual Rent	Rent per All Animal Types for Location
Georgia	Cats	34	58	0	0
Georgia	Dogs	10	58	0	0
Georgia	Birds	14	58	0	0
Total		58	58	0	103,148

The rent per all animal types for location total at the bottom of the table should be 0, but instead shows a value. The formula used for the rent per all animal types for location is:

Grand Total Site Types =

Rent per all animal types for location = DIVIDE(SUM('Key Costs Table'[Annual Rent]), [Grand Total of all animal types for location])

Any idea as to why it's not totaling correctly?

Thanks!

topic Quick Measure showing totals when column values are zero in Custom Visuals Development Discussion

Quick Measure showing totals when column values are zero