Forum Discussion

kwhite0510's avatar
kwhite0510
Frequent Visitor
3 years ago

Count formula based on single criteria in same table

Good Afternoon,   I have a dataset that has sales agreements listed. Currently if the agreement has mulitple products listed, it will repete the total quantity (ie. duplicating it). I need a count ...
Ajendra's avatar
Ajendra
Icon for Resolver I rankResolver I
3 years ago

Hello,

I hope this message finds you well!!

 

Here is the dummy data which i took to execute this DAX.

 

Here is the dax i tried. check this once.

  • kwhite0510's avatar
    kwhite0510
    Frequent Visitor
    3 years ago

    Ajendra I believe this is on the right track for what I need! However, my formula is not showing valid. 

    Within this formula I have a formula for "Total Qnty"

    Please let me know if you see what could be wrong. Thank you very much