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 want to make a column in powerBI which counts the cells which are not blank in a range how columns (A, B, C, D)
In excel I would do =COUNTA( A : D )
But how can I make this count in powerbi on a range and not only a single column?
Thanks
Kristoffer
Solved! Go to Solution.
Hi @Kristofferaabo,
You need to use as many counta as necessary in your single measure:
Measure = Counta(Table[Col1]) + Counta(Table[Col2]) + Counta(Table[Col3]) +Counta(Table[Col4])
Or, it is better if you can first unpivot your data using the Query Editor in Power BI Desktop.
Perhaps:
= COUNTA([A]) + COUNTA([B]) + COUNTA([C]) + COUNTA([D])
Perhaps:
= COUNTA([A]) + COUNTA([B]) + COUNTA([C]) + COUNTA([D])
Hi @Kristofferaabo,
You need to use as many counta as necessary in your single measure:
Measure = Counta(Table[Col1]) + Counta(Table[Col2]) + Counta(Table[Col3]) +Counta(Table[Col4])
Or, it is better if you can first unpivot your data using the Query Editor in Power BI Desktop.
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |