Hi
I have a table that consists of 2 columns (Type,Value) there are some values that are blank means they are Zeros
I want to calculate the average of values including the blanks (ex Average of type A = (0.5+0.2+0)/3 not (0.5 +0.2)/2
I tried
type | value |
A | 0.5 |
A | 0.2 |
A | |
B | 0.8 |
B | 0.1 |
C | |
D | 0.3 |
E | 0.4 |
F | 0.2 |
F |
Solved! Go to Solution.
values ignores blanks, it would be best to set those blank values to 0 or use distinctcount which counts blanks
Proud to be a Super User!
values ignores blanks, it would be best to set those blank values to 0 or use distinctcount which counts blanks
Proud to be a Super User!
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
241 | |
56 | |
49 | |
45 | |
44 |
User | Count |
---|---|
280 | |
211 | |
82 | |
76 | |
75 |