Filter measure by another column

[sw123]

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!

[v-diye-msft]

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.

[amitchandak]

@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.