Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bhmiller89
Helper V
Helper V

Writing a Condition

Here's a snapshot of my data: Capture.JPG

 

I need a way to say whether or not an OrganizationName is considered CSP (IsCSP= CSP). However, each JobNum has multiple RateDesc, some rates are CSP and some aren't. I want to write a column or measure or something that say "If at least one RateDesc= "CSP", then this OrganizationName is CSP.  I need the OrganizationName as a whole to be considered CSP or NotCSP

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @bhmiller89,

 

From your description, I create some sample data, you can create calculated columns like below:

 

IsCSPNew = IF('Table3'[IsCSP]="CSP",1,0)

 

OrgName = IF(CALCULATE(SUM(Table3[IsCSPNew]),ALLEXCEPT(Table3,'Table3'[TSMDepartment],'Table3'[OrganizationName],'Table3'[Domain Name],'Table3'[JobNum])),
                      "CSP",
                      "NotCSP"
                  )

 

e1.PNG

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @bhmiller89,

 

From your description, I create some sample data, you can create calculated columns like below:

 

IsCSPNew = IF('Table3'[IsCSP]="CSP",1,0)

 

OrgName = IF(CALCULATE(SUM(Table3[IsCSPNew]),ALLEXCEPT(Table3,'Table3'[TSMDepartment],'Table3'[OrganizationName],'Table3'[Domain Name],'Table3'[JobNum])),
                      "CSP",
                      "NotCSP"
                  )

 

e1.PNG

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
anupampandey
Helper III
Helper III

@bhmiller89,

 

Could you share some sample please?

 

 

Thanks,

Anupam

MFelix
Super User
Super User

Hi @bhmiller89,

 

You can try the CONTAIN formula to have a measure that does that classification:

 

Measure = IF(
                     CONTAINS(
                                      Table,
                                      Table[IsCSP];
                                      "CSP");
                      "CSP";
                      "NotCSP"
                  )

Regards,

MFElix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.