How to multiply a measure with a conversion rate in an other column

MarcoW91 — Fri, 22 Oct 2021 15:25:12 GMT

Hello,

I got powerbi datatable and I would like to modify my measures to multiply it with specific conversion rates.

I got a column with products (there can be multiple lines per product) and a conversion rate which differs per product.

How can I adapt my measures without having problems with adding up values to show the right values (even when filtering).

When I add a column it adds up all conversion like 4 items with conversion 1 will show 4 in total (4*1).

Hope someone can help with an easy example 🙂

Thank you kindly!

Re: How to multiply a measure with a conversion rate in an other column

Greg_Deckler — Fri, 22 Oct 2021 15:36:27 GMT

MarcoW91 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.