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?

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:

    • parry2k's avatar
      parry2k
      Super User
      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I changed it but it doesn't affect anything parry2k