Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Measure Definition

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)
Need Help

4 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    Hi, Anonymous 

     

    you want

     new measure with distinctcount of opportunity_id
    or
    something else?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Dangar332
        Resident Rockstar
        2 years ago

        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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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