Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |