cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dataman123 Member
Member

Lookup ID to give me specific outcome

Hi, i have 2 columns one that has a customer ID and another that has if they are OnPrem or Cloud. What i am looking to do is do a look to say if they have both then output upgraded. Something along the lines of IF Customer ID has Cloud and On Prem then output Upgraded. any help will be amazingPOwer bi.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Lookup ID to give me specific outcome

Hi @dataman123

Create measures

Measure = CALCULATE(DISTINCTCOUNT(Sheet2[cloud or on prem]),ALLEXCEPT(Sheet2,Sheet2[customer id]))

Measure 2 = IF([Measure]=2,"upgraded",BLANK())

4.png

 

 

Best Regards

Maggie

2 REPLIES 2
Community Support Team
Community Support Team

Re: Lookup ID to give me specific outcome

Hi @dataman123

Create measures

Measure = CALCULATE(DISTINCTCOUNT(Sheet2[cloud or on prem]),ALLEXCEPT(Sheet2,Sheet2[customer id]))

Measure 2 = IF([Measure]=2,"upgraded",BLANK())

4.png

 

 

Best Regards

Maggie

dataman123 Member
Member

Re: Lookup ID to give me specific outcome

@v-juanli-msft thank you for your helpo is there a way doing this as a new column rather than a measure or in DAX?