Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

Pls provide test data and detail desire result.

 

Best Regards,
Adamk Kong

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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!  🙂

    AcctSum of 4A Cass CTSum of 4B Cass CTSum of 5A Cass CTSum of 5B Cass CTKEEP OR REMOVE
    12348877REMOVE
    15261111REMOVE
    65231011KEEP
    85982222REMOVE
    99883122REMOVE