Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I am trying to count non blank fields across a row that are not in order. As an example, I only want it to look at columns B,C,& E to provide that count. How am I able to achieve this?
A | B | C | D | E | F | Count |
20 | 4 | 5 | 4 | 1 |
Any help GREATLY appreciated.
Solved! Go to Solution.
Thank you! It worked!
Hi @YcnanPowerBI ,
If I understand correctly, the issue is that you want to count non-blank fields across a row. Please try the following methods and check if they can solve your problem:
1.Create the simple Table.
2.Select the table and click on New column to create a custom column.
3.Enter the following DAX formula for the new column.
Column =
VAR CountB = IF(NOT(ISBLANK('Table'[B])), 1, 0)
VAR CountC = IF(NOT(ISBLANK('Table'[C])), 1, 0)
VAR CountE = IF(NOT(ISBLANK('Table'[E])), 1, 0)
RETURN CountB + CountC + CountE
4.Drag the new column into the table visual.
5.The result is shown below.
Looking forward to your reply.
Best Regards,
Wisdom Wu
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |