Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ?   
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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