topic Re: DAX Formula for column not working in DAX Commands and Tips

DAX Formula for column not working

Anonymous — Thu, 25 Jan 2024 22:00:27 GMT

Hello all,

I have a problem with a DAX column. The issue is that it is bringing in the unwanted results. Here is an example: If the Number which is an "AccountNumber" is the same within the group and the columns 4A, 4B, 5A and 5B say ANYTHING other than "Complete" than it should say "KEEP" else "REMOVE. Because the below table has "Complete" and the field "Numbers are all the same, it should say "REMOVE.

With my initial DAX formula, I see that it is not correct, see below examples. Any assistance you can provide, I would greatly appreciate. Thank you in advance! 🙂

Aother example:

Re: DAX Formula for column not working

Anonymous — Fri, 26 Jan 2024 02:52:45 GMT

Hi Anonymous ,

You can try formula like below:

NewColumn = IF( COUNTROWS(FILTER(YourTable, YourTable[nber] = EARLIER(YourTable[nber]) && ( YourTable[4A Status] <> "Complete" || YourTable[4B Status] <> "Complete" || YourTable[5A Status] <> "Complete" || YourTable[5B Status] <> "Complete" ) )) > 0, "KEEP", "REMOVE" )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: DAX Formula for column not working

Anonymous — Fri, 26 Jan 2024 14:38:30 GMT

hello v-Kongfanf-msft,

Thank you, but that didn't work. It yielded the following results. It says "KEEP", but it should say "REMOVE" because within that group of Numbers which is an Account Number, they say "Complete" across the rows of 4A, 4B, 5A, and 5B.

Re: DAX Formula for column not working

Anonymous — Wed, 31 Jan 2024 08:24:34 GMT

Hi Anonymous ,

Pls provide test data and detail desire result.

Best Regards,
Adamk Kong

Re: DAX Formula for column not working

Anonymous — Thu, 01 Feb 2024 16:07:24 GMT

Hi v-kongfanf,

Here is some test data: This data is coming from a report that has counted the number of "Completes per Acct#. It seems like whatever DAX I create wants to count from the original report. I just need to formula to affect the current table not the detail table...
Now, what I need is the DAX that says if any of the numbers across this table have a zero there, then "KEEP", "REMOVE". Simple enought right. NO, not for me...its been very hard to make this happen. If you can assist with this I would be most grateful! 🙂

Acct	Sum of 4A Cass CT	Sum of 4B Cass CT	Sum of 5A Cass CT	Sum of 5B Cass CT	KEEP OR REMOVE
1234	8	8	7	7	REMOVE
1526	1	1	1	1	REMOVE
6523	1	0	1	1	KEEP
8598	2	2	2	2	REMOVE
9988	3	1	2	2	REMOVE