Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good.
I have read several related posts, but I can not show only the data that is not at zero, I give the example:
I have two product consumption tables, related to a product table with its code.
I make the total consumption (SUM) and calculate its difference.
When I show the summary, I see values at € 0, I have tried filtering for the difference, but I cannot, since it is the case that some give € 0 as a result.
One may have consumption in one year if and in another not or vice versa
Any ideas? This is the situation I have:
So you do not want to show records where all three columns are zero? Please confirm my understanding.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |