Forum Discussion

chrisgehm's avatar
chrisgehm
Helper III
9 years ago
Solved

Divide 2 columns

Hi!   I've got a simple table in excel, where I have Name, Amount1 and Amount2   I need to show in PBI the diference betwen both and after that, I need to divide the diference with Amount1. Th...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    You need to use only MEASURES for this! :smileyhappy:

     

    Amt1 Total = SUM('Table'[Amount1])

Amt2 Total = SUM('Table'[Amount2])

Difference = [Amt1 Total] - [Amt2 Total]

Divide = DIVIDE ( [Difference], [Amt1 Total], 0 )
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi chrisgehm

 

It's a bit hard to answer your question without a pic of the data at least.

I assume you tried to solve your problem in DAX?

chrisgehm's avatar
chrisgehm
Helper III
9 years ago

Anonymous

 

This is the excel

 

 

This is what I have in PBI:

 

 

Do you know why the division is not correct?

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    You need to use only MEASURES for this! :smileyhappy:

     

    Amt1 Total = SUM('Table'[Amount1])

Amt2 Total = SUM('Table'[Amount2])

Difference = [Amt1 Total] - [Amt2 Total]

Divide = DIVIDE ( [Difference], [Amt1 Total], 0 )
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Sean

      which would have been my solution too. You were faster :manhappy:

    • chrisgehm's avatar
      chrisgehm
      Helper III
      9 years ago

      Sean And if I want to get the values per Name?

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        You will get the values per name in the Table - you have the names on the Rows! :smileyhappy:

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I have 2 columns Im using for calcluation: Crashes, TotalInstalls

      Using the syntax posted, I get an error:

      Amt1 Total = SUM('PerCapita30'[Crashes])
      Amt2 Total = SUM('PerCapita30'[TotalInstalls])
      Difference = [Amt1 Total] - [Amt2 Total]
      Divide = DIVIDE ( [Difference], [Amt1 Total], 0 )
      T
      Sean wrote:

      You need to use only MEASURES for this! :smileyhappy:

       

      Amt1 Total = SUM('Table'[Amount1])

Amt2 Total = SUM('Table'[Amount2])

Difference = [Amt1 Total] - [Amt2 Total]

Divide = DIVIDE ( [Difference], [Amt1 Total], 0 )

      he syntax for 'Amt2' is incorrect. (DAX(SUM('PerCapita30'[Crashes])Amt2 Total = SUM('PerCapita30'[TotalInstalls])
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    mhhh, worked with your example on the pics, worked fine...

    How did you create the measures value1, value2 and differene