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: Produc...
Need Help
  • 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!

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

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
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!