Forum Discussion

bobbybamber's avatar
bobbybamber
Frequent Visitor
8 years ago
Solved

Segmenting A Measure Within A New Measure

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

  • bobbybamber's avatar
    bobbybamber
    8 years ago

    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!

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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

  • 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's avatar
      bobbybamber
      Frequent Visitor

      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!