Product flagging based on raw material

[mcash]

I am trying to create a condition to identify Products that will be kept in, reviewed, or removed from my portfolio based on the priority of the raw materials that go into each product. At first I thought this would be easy by stating that any Keep, New, and High Priority = 1, Review = -1, and Low Priority = 0. Then create a measure to multiply the raw material priorities together and the Keep, Review, or Remove would be based on the calculation. This works, except I want a condition where if there is a combination of high priority, keep, and low priority it would be flagged as review. The issue I am running into with my measure is since there is a Low Priority raw material it is calculated as 0; i.e. flagged as remove.

Any thoughts on how to properly accomplish this through DAX?

[Greg_Deckler]

@mcash Can you provide sample data as text?

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.