Measure Definition

[Anonymous]

Hi All,

I have created the below measure to calculate a metric but want to add a condition to the measure i.e distinct opportunity id count.

Basically I want to calculate my sales cycle where the opportunity count is distinct.

I have a column in my dataset having Opportunity ID.

How should I approach this? I tried few options but its not giving the correct number.

Calculation to calculate the Sales Cycle is below.

P_Sales Cycle = CALCULATE(AVERAGE(VW_F_PRODUCT_ACV[SALES_CYCLE]),VW_F_PRODUCT_ACV[PRODUCT_ACV] <> 0 && VW_F_PRODUCT_ACV[CLOSED_ACV_COUNT] = 1)

[Dangar332]

Hi, @Anonymous 

you want

 new measure with distinctcount of opportunity_id
or
something else?

[Anonymous]

Something like below but the last condition is not working so I want to understand is there anyother way to make this calculation?

[Anonymous]

I want to show the Sales Cycle number only just want to add a condition that what ever I'm calculating is being calculated on DISTINCTCOUNT of Opportunity IDs.

The above DAX is correct, I just want to add a condition to it that it doesn't pick duplicate IDs

[Dangar332]

hi, @Anonymous 

that's not a condition 
if you want to it as a condition then you have to compare with like (i.e >2, =0, <5) or something else
so clarify your problem