Forum Discussion
DAX Formula for column not working
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 gro...
Hi Anonymous ,
Pls provide test data and detail desire result.
Best Regards,
Adamk Kong
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 |