Measure for calculating revenue based on conversion percentage of product

[lsuresh89]

Hi friends,

I have some conversion percentages for some products. All I want to do is calculate using a measure, the forecasted revenue if the conversion % is multiplied by the pipeline.

Lets say this is the data:

Prod A - Conversion %  = 60

Prod B- Conversion % = 50

Prod C - Conversion %= 30

I have a slicer on the Product Type so my projections should change based on the product type selected. The problem I am having is that I am multiplying the pipeline with

CALCULATE(AVERAGE(Table[Column]))

in the measure and the aggregator is incorrect for my purpose. however I am not sure how I can just multiply with the % without using it. Can any one of you help me understand? Thanks.

Regards,

Lakshmi

[v-shex-msft · Accepted solution]

HI @lsuresh89 ,

It sounds like a weighted aggeration calculatiion requirement.
You can try to write measure with summarize function and switch function to manually calculate with weighted rate with aggregated results.
If you confused about coding formula, can you please share some sample data for test?

Regards,

Xiaoxin Sheng