Forum Discussion
jbaisley
Helper I
Helper IMultiply 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...
jbaisleyHelper I
Helper IThanks tamerj1 . IT doesn't like the `[Ratio]`. `Ratio` is a column, formatted as a decimal if that helps.
tamerj1
Community Champion
Community ChampionI thought [Ratio] is a measure
otherwise no need to summarize just
=
PRODUCTX (
'Table',
1 / 'Table'[Ratio]
)- jbaisley
No worries 🙂 I could have been clearer. That function is returning a repeating zero.0'
- tamerj1
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.