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.
Anonymous , if your issue has resolved from the above solutions, mark the solution.