Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create total pass/fail measure for visual

I am trying to make something like an AND function that compares the values in resultA, resultB, resultC, and resultD. I want a column called resultFINAL which returns "PASS" if and only if resultA, resultB, resultC, and resultD are "PASS"
 

 

Below is a measure I tried making, but I'm not sure where/how to put it in the visual.

Capture7.PNG

 

 

The reason I have 2 different ways of doing it is because when I add more data, the method in the first picture below takes too much memor to display. Therefore, I prefer to find a way to show this resultFINAL column using the style of the second picture.Capture8.PNG

Capture9.PNG

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    If I understand your requirement correctly that you want to know how to show the resultFINAL measure in the visual.

    Actually, I think that should be based on what data you want to see.

    In addition, from my point, you could show the resultFINAL measure as the first image and you could not put the resultA, resultB, resultC, and resultD in the table visual so that I think the performance will be better.

    If you still need help, feel free to ask.

    Best  Regards,

    Cherry

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello, v-piga-msft ,

       

      I tried what you mentioned and it's giving me all fails. Clearly it shouldn't be, because all of the values are less than my Upper Limit. See below

       

      I would like to know why it is still incorrect. 

       

      thank you