Forum Discussion
Divide DAX
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 ?
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.
4 Replies
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
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.
Anonymous , if your issue has resolved from the above solutions, mark the solution.
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
