Forum Discussion

Euro0681's avatar
Euro0681
Icon for Helper II rankHelper II
3 years ago
Solved

Dividing 2 columns

I am trying to simply divide 2 columns but when doing so i get a wrong value (Example Below) The correct value I'm looking for is "1.xxxx" , Note Column1 is displaying the sum and same concept...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Euro0681 

    create a Measure 

    DIVIDE ( SUM ( 'Table'[Column1] ), SUM ( 'Table'[Column2] ) )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Euro0681 

create a Measure 

DIVIDE ( SUM ( 'Table'[Column1] ), SUM ( 'Table'[Column2] ) )

Euro0681's avatar
Euro0681
Icon for Helper II rankHelper II
3 years ago

tamerj1 what if i need the value to be static and not change whenever extra fields are added, in other words is there a way to do this using a column as opposed to a measure?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Euro0681 

    CALCULATE ( DIVIDE ( SUM ( 'Table'[Column1] ), SUM ( 'Table'[Column2] ) ), ALL ( 'Table' ) )

    • Euro0681's avatar
      Euro0681
      Icon for Helper II rankHelper II
      3 years ago

      for more clarification I want the value to be static for every category. Example
      Catogry1 Total = Column1/Column2 = 2.02 (made up numbers)
      Category2 Total = Column1/Column2 = 1.02 (made up numbers)
       anytime i use Category1 with any other fields it should always remain '2.02' kind of like a group by in SQL?