Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Quick Measure showing totals when column values are zero

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. 

 

LocationAnimal TypeCount of Animal TypeGrant Total of All Animal Types for locationAnnual RentRent per All Animal Types for Location

Georgia

Cats

345800
GeorgiaDogs105800
GeorgiaBirds145800
Total 58580103,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!
0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors