Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |