Forum Discussion
Helper IIIFilter measure by another column
Hi,
I want to make a measure in Power BI where I multiply a column (quantity sold) by 0,72 BUT only for certain items (multiply). How do I do this? I´ve tried a lot of ways but can´t make it right.
Thanx in advance!
2 Replies
- amitchandak
Super User
sw123 , Assume you param to multiple, maybe what if parameter
you can have measure like
calculate(sum(Table[qty])*SelectedValue(Param[param]), filter(Table, Table[item] in {"Item1","Item2","Item3"}))
-calculate(sum(Table[qty])*SelectedValue(Param[param]))https://docs.microsoft.com/en-us/power-bi/desktop-what-if
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos. - v-diye-msft
Community Support
Hi sw123
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
