Forum Discussion

aravindh10's avatar
aravindh10
Icon for Helper I rankHelper I
7 years ago
Solved

% cost for a order

product name qty amount cost[amount/qty] cost%[cost/total cost) a 10 1000 100 33.33333 b 20 2000 200 66.66667     total 300 100% my measure is % cost per qty = var...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, aravindh10 

    Just try this formula to create a meausre

    % cost per qty = 
var _costytable= SUMMARIZE(abc,abc[MonthYear],"_cost1",DIVIDE([amount],[qty]))
var _totaltable=SUMMARIZE(ALLSELECTED(abc),abc[MonthYear],"_cost2",DIVIDE([amount],[qty])) return
DIVIDE(SUMX(_costytable,[_cost1]),SUMX(_totaltable,[_cost2]))

    Result:

    here is pbix file, please try it.

     

    Best Regards,

    Lin

     

aravindh10's avatar
aravindh10
Icon for Helper I rankHelper I
7 years ago
 field is available as Measurefield is available as Measurewhat I got using the measure which i got from the communitycostcost%Required  Measure
MonthYearAmountQty% cost per qtyAmount/Qtycost/total cost% cost per qty
19-May$20,379,005384051.026826333530530/152534%
19-Jun$11,952,378241420.958038303495495/152532%
19-Apr$4,957,26896100.998207489515515/152533%
    1525 100%
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, aravindh10 

Just try this formula to create a meausre

% cost per qty = 
var _costytable= SUMMARIZE(abc,abc[MonthYear],"_cost1",DIVIDE([amount],[qty]))
var _totaltable=SUMMARIZE(ALLSELECTED(abc),abc[MonthYear],"_cost2",DIVIDE([amount],[qty])) return
DIVIDE(SUMX(_costytable,[_cost1]),SUMX(_totaltable,[_cost2]))

Result:

here is pbix file, please try it.

 

Best Regards,

Lin