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]
)
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi jbaisley 

please try

=
PRODUCTX (
    SELECTCOLUMNS (
        SUMMARIZE ( 'Table', 'Table'[Location], 'Table'[Category] ),
        "@Ratio", [Ratio]
    ),
    1 / [@Ratio]
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

tamerj1 I went down that path. The syntax is broken, can't pick [Ratio] out of a summarized column that doesn't include it. Also, PRODUCTX('Table',1/[Ratio]) is equivalent and that returns 1.75.