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 wher...
Need Help
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