Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated Columns and Measure

Hi,   I'm trying to create a measure that looks at columns Journey Alias and Stop Comp over 5 mins and returns either Compliant or Not Compliant for a specific Journey Alias.   Eg. 101191351 shou...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi Anonymous ，

    You could  try the following measure:

    test =
    VAR not_compliant =
        CALCULATE (
            COUNT ( 'Table'[Stop Comp over 5 mins] ),
            FILTER (
                ALL ( 'Table' ),
                'Table'[Journey Alias] = MAX ( 'Table'[Journey Alias] )
                    && 'Table'[Stop Comp over 5 mins] = "Not Compliant"
            )
        )
    VAR at_all =
        IF ( not_compliant >= 1, "Not Compliant", "Compliant" )
    RETURN
        at_all

     

     

    Finally you will see:

     

     

    If this is not what you want, please describe what you want, thank you!

     

     

    Best Regards,

    Lucien

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

I think the ALLEXCEPT() function should work.  I can offer more help if you share the link from where i can download your PBI file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      That is not a file download link.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, 

    I'm not sure how to do this actually since I've never shared a powerbi file to an external user. I've published it in my workspace and clicked share there but it asks for an email address and the only link available was the report link at the bottom which I have already sent here.

     

    If you can direct me on how to do this then I'll be able to do so since I can't find a solution for this on here.