Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to calculate the number of null observation in each of my columns (except for one column) and then filter by that column.
E.g.
Table:
Col1 Col 2 Col 3 NonNull Col
abc | bbb | 1 | |
aaa | 2 | ||
bca | 3 |
Result:
NonNull Col | 3 | <- value in non null col |
No. of Blank Cells | 2 | <- Count of null values per row |
Is there a way to do this that does not involve creating a metric for each column?
Thanks!
@iiasadw ,
@iiasadw wrote:
Hi,
I would like to calculate the number of null observation in each of my columns (except for one column) and then filter by that column.
E.g.
Table:
Col1 Col 2 Col 3 NonNull Col
abc bbb 1 aaa 2 bca 3
Result:
NonNull Col 3 <- value in non null col No. of Blank Cells 2 <- Count of null values per row
Is there a way to do this that does not involve creating a metric for each column?
Thanks!
Could you please explain why the "Count of null values per row" is always 2? Could you please format the sample table?
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |