I have a matrix made in Power BI being read from a SQL Server database. I have a column called Name that contains duplicates along with a column called stack, where as shown in the example table, we can have a name that either contains 1 duplicate stack value or it can also have 1 stack value listed in 2 names, we then have a unique SubName that corresponds with the different combinations of Name and Stack.
Along with that we have 2 columns that are called Value1 and Value2; they both should be representing the same value but since it's reading a software's database and the logic is not yet ideal, we are dealing with some overstated values and duplicates.
I created a conditional column that reads value1 if a checkbox is marked or not and otherwise value2.
I want to create a column that displays the results in red, where for every distinct name even if it has a duplicated stack, to read either Value1 or Value2 whichever is lowest.