The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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