Segmenting A Measure Within A New Measure

[bobbybamber]

Hi guys,

So - say I've got a measure that measures conversion rate. Let's say the overall conversion rate (called "CNVR" as a calculated measure) is 5%. Let's say that varies by product:

Product A = 7.5%
Product B = 6%
Product C = 3%

Now, lets say I wanted to insert that calculated measure within a new mesaure. E.g if I was trying to project how many leads I'd require to hit my targets, I'd divide my targets by my conversion rate:

E.g. Leads Required = [Sales Target Volume]/[CNVR]

Which would take my sales target volume and divide it by 5%.

However, say I wanted to have that field pull in the conversion rate specifically of Product A, *without* segmenting any other part of the page, how would I do that?

Basically I want to have:

Leads Required = [Sales Target Volume]/[Product A CNVR]. I can insert Product as a slicer on the page, but I don't want to do that.

Thanks,

Bob

[v-xjiin-msft]

Hi @bobbybamber,

Generally, if you only want to get the conversion rate of Product A. You can add a Filter() in your measure to filter the product only equals to A.

However since we don't know your measure formula or your table structure. It is hard for us to guess how to add a specfic Filter(). So could you please share us more detailed information like your source table structure, measure formula or some sample data if possible? Otherwise, we can only make a guess.

Thanks,
Xi Jin.

[bobbybamber · Accepted solution]

Thanks guys, think I've solved it by using CALCULATE(*MEASURE*,FILTER) - sorry if I explained it poorly but looks like it's done the job. Help is always appreciated!

[Greg_Deckler]

If you have a table for your conversion rates, you should be able to use LOOKUPVALUE in your measure.