Simple DAX function?

[Anonymous]

@Phil_Seamark - calling on you for your power BI wizard-like capabilities!

I am trying to write what I think would be a simple DAX function without an operation.

Two columns:

• Customer Spend
• Cost per Thousand

Calculation should be Customer Spend/Cost per Thousand * 1000 = Number of Units

Any suggestions...when I put an operation in front of the numerator and denominator the calculation works, but I get an incorrect answer.

Johnny has a $500 budget to purchase apples.  The cost for apples is $20 cost per thousand.  How many apples can Johnny buy based on his budget.  $500/$20*1000 = 25,000 apples.

[vanessafvg]

@Anonymous 

what are you expecting?

measure = divide($500, ($20 * 1000))

[dkay84_PowerBI · Accepted solution]

@Anonymous I'm assuming you have a table with each row having a cost per thousand and a price and you are trying to calculate units for each row?  You need a calc column for something like that, unless you are trying to evaluate the expression for every row AND THEN summarize (i.e. sum, average etc.) in which case you could use a SUMX or similar function.

In any event, once you load your data to the data model, you can use DAX by right clicking on the table name and choosing Calculated Column.  Then write your function.

I would recommend doing simple calc columns like this in query editor if possible.  You will get better compression and performance of the data model if you add the column there rather than with DAX.

[dkay84_PowerBI]

I think this should be a calc column not a measure.  Is that what you have tried?

[Anonymous]

I haven't tried that.  Can you offer some details on how to do, and the expression itself?

Thank you!