Forum Discussion

SarahHope's avatar
SarahHope
Icon for Helper II rankHelper II
3 years ago
Solved

Syntax for Calculated Column to Filter results from three fields using OR logic

Hello! I'm brand new to Power BI. I'm trying to create a calculated column containing a filter for three other columns in the same data sheet using OR logic. I want a calculated column showing me...
"Calculated Column"
calculated
Filter
logic
OR
  • SarahHope's avatar
    SarahHope
    3 years ago

    FreemanZ - Thank you SO much!  That gets me much closer. 

    What is the significance of the TRUE, TRUE, FALSE at the end?

    I like to understand why I am doing what I'm doing.

     

    Apparently, since the 'Change Type' field is not boolean and the other two fields are,  FILTER is giving me an error.

    So, I am trying to make another calculated column called "Emergency" that returns "True" for any change where Change Type = "Emergency Change"

     

     I have tried this:

    Emergency = CONTAINS(FILTER('Full SharePoint Export'[Change Type]),"Emergency Change")
    But am getting "too few arguements were passed to the FILTER function."
     
    I'll keep researching and let you know if I figure it out.  I'd be happy for advice too!
     
    Thanks,
    Sarah
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi SarahHope 

try like:

PIR = 
IF('Full SharePoint Export'[Expedited]=TRUE || 'Full SharePoint Export'[Change Type] = "Emergency Change" || 'Full SharePoint Export'[Resulted in Outage] = TRUE, TRUE, FALSE)
SarahHope's avatar
SarahHope
Icon for Helper II rankHelper II
3 years ago

FreemanZ - Thank you SO much!  That gets me much closer. 

What is the significance of the TRUE, TRUE, FALSE at the end?

I like to understand why I am doing what I'm doing.

 

Apparently, since the 'Change Type' field is not boolean and the other two fields are,  FILTER is giving me an error.

So, I am trying to make another calculated column called "Emergency" that returns "True" for any change where Change Type = "Emergency Change"

 

 I have tried this:

Emergency = CONTAINS(FILTER('Full SharePoint Export'[Change Type]),"Emergency Change")
But am getting "too few arguements were passed to the FILTER function."
 
I'll keep researching and let you know if I figure it out.  I'd be happy for advice too!
 
Thanks,
Sarah