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

     

ZunzunUOC's avatar
ZunzunUOC
Icon for Resolver III rankResolver III
7 years ago

You could use a calculated column like this:

 

% cost per qty = cost[cost[amount/qty]]]/SUM(cost[cost[amount/qty]]])

 

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

i want measure.Only available columns are qty and amount

  • ZunzunUOC's avatar
    ZunzunUOC
    Icon for Resolver III rankResolver III
    7 years ago

    Please, review your raw data, the second row is wrong and if cost would equal for two row.

     

    And the other hand, calculated columns are the best way to get your goal.

     

    Column cost would be:

     

    Cost = cost[amount]/cost[qty]