Forum Discussion
Multiply Measure by Column
EVEAdmin hard to write the exact formula with the data supplied, but basically you need something like:
measure = SUMX('Sales', 'Sales'[Quatntity] * RELATED('Store'[difference]))
EVEAdmin hard to write the exact formula with the data supplied, but basically you need something like:
measure = SUMX('Sales', 'Sales'[Quatntity] * RELATED('Store'[difference]))
SpartaBI thank you very much,
even though the data supplied were limited, you provided the solution I needed, very quickly.
Appreciated.EVEAdmin my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂
