Multiply a measure with a selection of cells from another table

[Anonymous]

Dear All, 

I am fairly new to Power Bi and I was woundering if it is possible to multiply a created measure with a table with different percentages. In the report view it should be possible to choose the applicable percentage and it should then automatically use this filter to multiply the percentage with the measure. 

Is there a possibility to do this? 

Thank you in advance! 

[TomMartens · Accepted solution]

Hey @Anonymous 

I'm not sure if I understand your requirement 100%, but I guess you can achieve what you want by using parameters:

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

If this is not what you are looking for you might consider to elaborate more about what you are trying to achieve. You might also think about to create a pbix with sample data, but still reflects your data model. Upload the pbix file to onedrive or dropbox and share the link.

Hopefully this gets you started

Regards,

Tom