write a calcaulated measure to identify blanks

[powerbidu]

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

[v-hashadapu]

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.

[rohit1991]

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"
)

[mdaatifraza5556 · Accepted solution]

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.