topic Re: write a calcaulated measure to identify blanks in DAX Commands and Tips

write a calcaulated measure to identify blanks

powerbidu — Mon, 24 Mar 2025 10:07:32 GMT

I have created a table in Power BI that contains multiple columns. I would like to create a measure that returns "Yes" if any column in a row is blank, and "No" if all the columns are filled. Please note: The columns can change depending on which columns I select to include in the table.

Results should follow the 'Exception' Column.

Trade	Date	Time	Exception?
123	XXX		Yes
124	XXX	YYY	No
125		YYY	No
126	XXX	YYY	No
127			Yes

Thank you in advance

Re: write a calcaulated measure to identify blanks

mdaatifraza5556 — Tue, 25 Mar 2025 11:14:45 GMT

Hi powerbidu

Can you please try the below DAX.

Exception =

SWITCH(TRUE(),

ISBLANK(SELECTEDVALUE(Trade1[date])) || ISBLANK(SELECTEDVALUE(Trade1[time])), "Yes",

"No"

)

If this answers your questions, kindly mark this as a solution.

Re: write a calcaulated measure to identify blanks

rohit1991 — Tue, 08 Jul 2025 09:45:03 GMT

Hi powerbidu ,
To create a measure in Power BI that dynamically checks if any column in a row is blank and returns "Yes" if so, or "No" if all are filled, you need to be mindful that measures do not evaluate row-by-row by default like calculated columns do. However, if you're working with a fixed set of known columns in your visual, you can create a custom DAX measure using conditional logic to check for blanks in each field. While it won’t respond dynamically to column visibility in the visual (since DAX measures must reference specific columns), you can still create a flexible measure that captures the most relevant fields and flags exceptions as needed. This measure can then be used in the “Exception?” column to identify rows that contain any missing values.

Exception? = IF ( OR ( ISBLANK(YourTable[Trade]), ISBLANK(YourTable[Date]), ISBLANK(YourTable[Time]) ), "Yes", "No" )

Re: write a calcaulated measure to identify blanks

v-hashadapu — Sat, 29 Mar 2025 10:09:59 GMT

Hi powerbidu , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.