Forum Discussion
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 ...
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 HI,
You may still use the Except function. Please try below to get the table of UniqueID which are not delivered as PO
notDelivered_Table =
EXCEPT(all(PO[UniqueID],PO[item Name],PO[Qty]),all(deliveryNote[UniqueID],deliveryNote[item Name],deliveryNote[Qty]))
to get the number of ID, make a measure with countrows(notDelivered_Table).
Hope, this helps
Something wrong, It's type error. I have tested it using your table.
if you can share your pbix table, let me check it.
