Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PLEASE HELP

I am trying to write this dax measure as a dax column but when i write this as column then the result we get is only fail but we should get both according to my data so can anyone help how to write this formula so that I get column containg pass and fail both value.

 

SWITCH(TRUE(),COUNT(integration[MRB Lead])==COUNT(integration[Event])&&COUNT(integration[TeamLeader])==COUNT(integration[Event])&&COUNT(integration[TeamFacilitator])==COUNT(integration[Event])&&COUNT(integration[TeamSponsor])==COUNT(integration[Event]),"pass","fail")
Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Hope you are creating a measure

     


    SWITCH(TRUE(),COUNT(integration[MRB Lead]) = COUNT(integration[Event])
    && COUNT(integration[TeamLeader])= COUNT(integration[Event])
    && COUNT(integration[TeamFacilitator])= COUNT(integration[Event])
    &&COUNT(integration[TeamSponsor])= COUNT(integration[Event]),"pass","fail")

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak  my issue is as due to this measure I am doing color coding and i am gettung red color on event 8 but the event who does not match this condition is only 1 so how to see only 1 instead of 8 in the given table and in other table.

      how to get specific count of failure 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        amitchandak my main issue is that I dont want 8 i want only 1 which is failing but I am getting total event count that is 8 so do you kow ho to get only one vent that is failing?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago
      Column = SWITCH(TRUE(),COUNT(integration[MRB Lead])==COUNT(integration[Event])&&COUNT(integration[TeamLeader])==COUNT(integration[Event])&&COUNT(integration[TeamFacilitator])==COUNT(integration[Event])&&COUNT(integration[TeamSponsor])==COUNT(integration[Event]),"pass","fail") amitchandak  I am creating this column to use as filter but this filter only getting fail as result whu is this happening can you help me in this