Hi Guys,
I have a corporate powerbi with a size limit, so I want to create a measure and not add another column to take up space.
I have 3 tables
MasterData, CBO (custoemer Backorders) & OnOrder (Supplier on order(
all tables are linked to the Masterdata as the primary link and there are no duplication in the Masterdata table.
MasterData fields --> Material, Category etc
CBO fields ---> Material, Customer, Outstanding Qty
OnOrder fields ---> Material, OrderNo, OrderQty
I then want to create a report that looks at the OnOrder data, but sums and reports the outstanding qty of customer backorders
Material -- OnOrder|OrderNo, OnOrder|OrderQty, CBO|Outstanding Qty
The issue that I'm having is the multiple lines where a single line was expected. I think becuase I'm not directly linked to a table it's creating an error, but I don't know how to fix this
Can anyone tell me how to write the measure?
Thanks!
I have a corporate powerbi with a size limit, so I want to create a measure and not add another column to take up space.
I have 3 tables
MasterData, CBO (custoemer Backorders) & OnOrder (Supplier on order(
all tables are linked to the Masterdata as the primary link and there are no duplication in the Masterdata table.
MasterData fields --> Material, Category etc
CBO fields ---> Material, Customer, Outstanding Qty
OnOrder fields ---> Material, OrderNo, OrderQty
I then want to create a report that looks at the OnOrder data, but sums and reports the outstanding qty of customer backorders
Material -- OnOrder|OrderNo, OnOrder|OrderQty, CBO|Outstanding Qty
The issue that I'm having is the multiple lines where a single line was expected. I think becuase I'm not directly linked to a table it's creating an error, but I don't know how to fix this
Can anyone tell me how to write the measure?
Thanks!
