Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

filter Duplicates with 2 columns - HELP!

Hi,   Lets say I have this Data       I need to only count the Carrier Reference that has a status of "Carrier Invoice Posted" in my final numbers, so that i can show true #s (no du...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    thank you for the Reply Vijay,

     

     

    I think I posted my question incorrectly if a carrier reference has a duplicate with a LifeCycleStatus = Reject & LifeCycleStatus = Carrier Invoice posted, then I only want to count the reference of the carrier invoice posted status.

     

    Not sure if this can be obtained with a DAX formula or a step in the transform data.

VijayP's avatar
VijayP
Community Champion
5 years ago

Anonymous 

Also you can try 

CALCULATE(

Count( Life cycle status),
Life Cycle status = "Carrier Invoice Posted in SAP ERP")

LEt me know if it solves

Anonymous's avatar
Anonymous
Not applicable
5 years ago

thank you for the Reply Vijay,

 

 

I think I posted my question incorrectly if a carrier reference has a duplicate with a LifeCycleStatus = Reject & LifeCycleStatus = Carrier Invoice posted, then I only want to count the reference of the carrier invoice posted status.

 

Not sure if this can be obtained with a DAX formula or a step in the transform data.