Divide DAX

[Anonymous]

Hi I Have a calculation I'm doing

TotalItems-TotalErrors/Totals Items 

When doing this I'm get a number way off as seen in the "column"

Any help ? 

[v-yiruan-msft]

Hi @rutabah12,

Whether your expected result is to get the ratio of the number of correct items to the total number of items? If yes, you can replace the previous formula with the below one: (Suppose that the field TotalErrors and TotalItems are the aggregated values from the calculated columns or measure )

Column = ( [TotalItems]- [TotalErrors] ) / [TotalItems]

 

If you still can’t get the correct results after replaced, please provide your data model structure and the formulas applied in the field TotalErrors and TotalItems. Thank you.

 Best Regards

Rena

[amitchandak]

@Anonymous , if your issue has resolved from the above solutions, mark the solution.

[v-yiruan-msft]

Hi @Anonymous,

Whether your expected result is to get the ratio of the number of correct items to the total number of items? If yes, you can replace the previous formula with the below one: (Suppose that the field TotalErrors and TotalItems are the aggregated values from the calculated columns or measure )

Column = ( [TotalItems]- [TotalErrors] ) / [TotalItems

If you still can’t get the correct results after replaced, please provide your data model structure and the formulas applied in the field TotalErrors and TotalItems. Thank you.

 Best Regards

Rena

[Greg_Deckler · Accepted solution]

Tough to say perhaps, but I would try this:

([TotalItems] - [TotalErrors]) / [Totals Items]

Even better:

DIVIDE( [TotalItems] - [TotalErrors], [Total Items],0)

Assumes those are all measures or all columns if you are creating a column in a table.