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 )
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
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])