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

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

 

 

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

pratichi's avatar
pratichi
Frequent Visitor
5 years ago

colacan Thanks it worked, but I found a better way using merge queries.
Merging the tables and expanding to pull DN no and Unique ID for each of the lines provided me the visibility.