Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |