cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
garuth01 Frequent Visitor
Frequent Visitor

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Create total pass/fail measure for visual

Hi @garuth01 ,

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
garuth01 Frequent Visitor
Frequent Visitor

Re: Create total pass/fail measure for visual

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 belowreplycapture.PNG

 

I would like to know why it is still incorrect. 

 

thank you

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 6 members 2,890 guests
Please welcome our newest community members: