Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 amazing
Solved! Go to Solution.
Hi @Anonymous
Create measures
Measure = CALCULATE(DISTINCTCOUNT(Sheet2[cloud or on prem]),ALLEXCEPT(Sheet2,Sheet2[customer id])) Measure 2 = IF([Measure]=2,"upgraded",BLANK())
Best Regards
Maggie
Hi @Anonymous
Create measures
Measure = CALCULATE(DISTINCTCOUNT(Sheet2[cloud or on prem]),ALLEXCEPT(Sheet2,Sheet2[customer id])) Measure 2 = IF([Measure]=2,"upgraded",BLANK())
Best Regards
Maggie
@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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |