Forum Discussion

pratichi's avatar
pratichi
Frequent Visitor
5 years ago
Solved

Comparing Line Count in two different tables

Hi guys, Still learning DAX, so not sure how I can do this.    I have a PO line table, where I have 8 items in an PO.   UniqueID   item Name   Qty   PO #   line no PO001-a-1   a ...
DAX Calculation
Distinct Counts
  • colacan's avatar
    colacan
    5 years ago

    Something wrong, It's type error. I have tested it using your table. 

     

     

    if you can share your pbix table, let me check it.

colacan's avatar
colacan
Resolver II
5 years ago

pratichi Hi, pratichi, if you want get the list of UniqueID which are not delivered (which don't exist in Delivery Note), you may use dax Except fuction to solve the proble. (https://docs.microsoft.com/en-us/dax/except-function-dax)

 

for your question,

 

Create a table, 

NotDelivered = except( values('PO'[UniqueID], values('Delivery Note'[UniqueID]))  whould return all the list of UniqueID which are not delivered.

 

Hope this helps you.