Forum Discussion
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...
Hi jbaisley
please try
=
PRODUCTX (
SELECTCOLUMNS (
SUMMARIZE ( 'Table', 'Table'[Location], 'Table'[Category] ),
"@Ratio", [Ratio]
),
1 / [@Ratio]
)
Thanks tamerj1 . IT doesn't like the `[Ratio]`. `Ratio` is a column, formatted as a decimal if that helps.
I thought [Ratio] is a measure
otherwise no need to summarize just
= PRODUCTX ( 'Table', 1 / 'Table'[Ratio] )No worries 🙂 I could have been clearer. That function is returning a repeating zero.0'
Are you using the dmsame data as pet the example? If so you shouldn't get 0. Anyway, please increase the number of decimal points just yo confirm you're actually getting zero not a number rounded to zero.
do you zero or blank values in the ratio column?
also advise if you gave a unique date or index column.