Forum Discussion

metin's avatar
metin
Frequent Visitor
5 years ago

Create a comparison column using 3 tables

Dear All,   I am working on a report that I need your help and ideas. I have 3 tables that I am working on direct query mode to create report.   These 3 tables looks like simply as below in terms...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi， metin 

Have  you tried function "selectvalue"?

Measure = SELECTEDVALUE(Orders[Order Qty])-SELECTEDVALUE('In Transit'[Quantity In Transit])-SELECTEDVALUE(Inventory[Quantity Available])


Best Regards,
Community Support Team _ Eason