Forum Discussion

MMJ369's avatar
MMJ369
Frequent Visitor
7 years ago
Solved

measure with data from 2 tables

I want to create a measure that uses a measure in table one divided by a value in a summarized table. I can show both values in a table vizualization but I can not get the measure to work.   2 Tab...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    MMJ369 Please try using "New Table" option

     

    DemandQuantityResult = ADDCOLUMNS(Demand
                                 ,"POQty",LOOKUPVALUE(Quantity[POQty],Quantity[item],Demand[item])
                                 ,"% Demand",ROUND((LOOKUPVALUE(Quantity[POQty],Quantity[item],Demand[item])/Demand[demand])*100,0))

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

MMJ369 Please try using "New Table" option

 

DemandQuantityResult = ADDCOLUMNS(Demand
                                 ,"POQty",LOOKUPVALUE(Quantity[POQty],Quantity[item],Demand[item])
                                 ,"% Demand",ROUND((LOOKUPVALUE(Quantity[POQty],Quantity[item],Demand[item])/Demand[demand])*100,0))

MMJ369's avatar
MMJ369
Frequent Visitor
7 years ago

Thanks for the suggestion.

 

I do not have a table with the quantities. The PO quantities are only held in a measure within the PO-table.

Should I first create a table with the first two columns and then use your dax to add the rest?

 

 

I really need to be able to use the demand per item in the PO table.

 

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago

    MMJ369 Please create an intemediate "Quantity" table by using your "POs" table, grouping on Item and suming up the quantity