Creating a measure with multiple conditions

[Rsanjuan]

I am looking to calculate # of bids, when Job Phase equals certain conditions.  How do we do it for more than one condition?

NumberofSales = Calculate(DISTINCTCOUNT(Master[Bid_Number__c]),Master[Job.Job_Phase__c]="closed")

For example, I want to include not only "closed" but "in process", "confirmed"

Thanks!

[samdthompson · Accepted solution]

check that the calculated colum is working as expected. Without seeing more of the model its hard to see whats wrong. 

//if this is a solution please mark as such

[samdthompson]

thats becasuse you are putting "" around the 1 making it text not numeric. Swap out a SUM() for the distinct count and put the FILTER()

NoOfSales = Calculate(SUM(Master[Bid_Number__c]),FILTER(Master[ConditionSales])=1)

//If this is a solution please mark as such

[Rsanjuan]

@samdthompson

The dax expression works, but it is not returning a number.  It's returning a (blank)

[samdthompson · Accepted solution]

check that the calculated colum is working as expected. Without seeing more of the model its hard to see whats wrong. 

//if this is a solution please mark as such