Forum Discussion

jbaisley's avatar
jbaisley
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
3 years ago

I have returned for advice on extending this function! Suppose I have a slicer for the symtopms in the first post. How can I filter the Odds[Ratio] to the selected values of Odds[Category]?

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

jbaisley 

The measure should be filtered with no issues