IF ISBLANK Return Blank

Question

&nbsp;Hi,&nbsp;I have a one table, that table contain multiple columns and count. I am trying to build final status based on the columns A:G.&nbsp;ITEMABCDEFGREESULT1232&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE12446&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MULTIPLE1251111&nbsp;&nbsp;&nbsp;MULTIPLE12611&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MULTIPLE12711&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MULTIPLE1281&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1291&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1301&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1311&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1321&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1331&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1341&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1361&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE13731&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MULTIPLE13831&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MULTIPLE139112&nbsp;&nbsp;&nbsp;&nbsp;MULTIPLE1402&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1412&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE1421111&nbsp;&nbsp;&nbsp;MULTIPLE14331282&nbsp;&nbsp;MULTIPLE1442&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ONE14542211&nbsp;&nbsp;MULTIPLE146&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;147&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;148&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I am applying below mentioned DAX and it's working well but it will give a wrong result (Multiple) were columns are blanks (A:G) but desired result is blanks. Please refer 146,147 and 148.&nbsp;Desired Result = IF(IF(ISBLANK(Table1[A]),0,1)+IF(ISBLANK(Table1[B]),0,1)+IF(ISBLANK(Table1[C]),0,1)+IF(ISBLANK(Table1[D]),0,1)+IF(ISBLANK(Table1[E]),0,1)+IF(ISBLANK(Table1[F]),0,1)+IF(ISBLANK(Table1[G]),0,1)=1,"One","Multiple")

philiptreacy · Accepted Answer

Hi&nbsp;Saxon10&nbsp;
&nbsp;
Download sample PBIX file
&nbsp;
Modify the DAX to this
Result =

VAR _Count = IF(ISBLANK(Table1[A]),BLANK(),1)+IF(ISBLANK(Table1[B]),BLANK(),1)+IF(ISBLANK(Table1[C]),BLANK(),1)+IF(ISBLANK(Table1[D]),BLANK(),1)+IF(ISBLANK(Table1[E]),BLANK(),1)+IF(ISBLANK(Table1[F]),BLANK(),1)+IF(ISBLANK(Table1[G]),BLANK(),1)

RETURN IF(_Count=1, "One", IF(ISBLANK(_Count), BLANK(), "Multiple"))

&nbsp;
Regards
Phil

Forum Discussion

IF ISBLANK Return Blank

2 Replies

Related content

IF ISBLANK Return Blank

ISBLANK() and IF(...=BLANK()) return different results

IsBlank

IF ISBLANK Return Blank

DAX issue ISBLANK

ITEM	A	B	C	D	E	F	G	REESULT
123	2							ONE
124	4	6						MULTIPLE
125	1	1	1	1				MULTIPLE
126	1	1						MULTIPLE
127	1	1						MULTIPLE
128	1							ONE
129	1							ONE
130	1							ONE
131	1							ONE
132	1							ONE
133	1							ONE
134	1							ONE
135	1							ONE
136	1							ONE
137	3	1						MULTIPLE
138	3	1						MULTIPLE
139	1	1	2					MULTIPLE
140	2							ONE
141	2							ONE
142	1	1	1	1				MULTIPLE
143	3	1	2	8	2			MULTIPLE
144	2							ONE
145	4	2	2	1	1			MULTIPLE
146
147
148