Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Divide two columns using DAX

I'm trying to divide two columns by using DAX. I've always struggled with this functionality in the past and thought I got this but I can't get my head around why it wouldn't work.  The formula doin...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous so as per your screen shot, you need to change data type to decimal number and decimal point to 2 or 3, didn't seems like you did that?

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous just to clarify, you are adding a measure, correct?

 

Based on screen shot, seems like you are doing count of disputes and transactions, although you said, you tried count, but not worked, what did you get? Same zero?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

yeah parry2k , it is a measure. 

When I do count: Disputes divided by Transactions = DIVIDE(count('Disputes'[Disputes]), count('Disputes'[Transactions])) - nothing changes.

 

The two columns I'm using in the formula are Transaction and Disputes IDs that I am counting in that table already and then trying to use DAX to get the ratio. 

 

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous did you checked the data type

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I just double checked for both columns.

      parry2k 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I did both parry2k , a calculated column and measure using same formulas:

         

        Column formula: Column = DIVIDE(count(Disputes[Disputes]),count(Disputes[Transactions]))

        Measure formula: Measure = DIVIDE(count(Disputes[Disputes]),count(Disputes[Transactions]))

         

        Output: