Forum Discussion

jbaisley's avatar
jbaisley
Helper I
3 years ago
Solved

Multiply Values from Single Column

Hello folks,   Hopfully, a simple one. I have column of odds by categories and location. The user can filter by category and location and I wan't to divide the remaining values together for a poole...
DAX
Power Query
  • tamerj1's avatar
    tamerj1
    3 years ago

    jbaisley 

    I thought [Ratio] is a measure 

    otherwise no need to summarize just

    =
PRODUCTX (
    'Table', 
    1 / 'Table'[Ratio]
)
jbaisley's avatar
jbaisley
Helper I
3 years ago

Thanks tamerj1 . IT doesn't like the `[Ratio]`. `Ratio` is a column, formatted as a decimal if that helps.

tamerj1's avatar
tamerj1
Community Champion
3 years ago

jbaisley 

Do you have a unique date or index column?