Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
I have the table below, and I want to calculate the average excluding blanks, in this case 4250. Something like
CALCULATE (average (units), units IS NOT BLANK)
Car | Units |
Mondeo | 8500 |
Fiesta | 0 |
Corsa |
Thanks!
Solved! Go to Solution.
Hey @Anonymous ,
the following measure should to it:
Avg Units =
CALCULATE(
AVERAGE( myTable[Units] ),
myTable[Units] <> BLANK()
)
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up.
Best regards
Denis
Blog: WhatTheFact.bi
Hey @Anonymous ,
the following measure should to it:
Avg Units =
CALCULATE(
AVERAGE( myTable[Units] ),
myTable[Units] <> BLANK()
)
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up.
Best regards
Denis
Blog: WhatTheFact.bi
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |