Conditional Column Based on Row and Column Conditions

[frank_fillingim]

I am fairly new to Power Bi.  I've completed a few visualizations but nothing that has challenged me to use specific row and column criteria to create a new conditional column.  My challenge is to create a count of objects based on certain conditions. What I have assets called "Brass Tag" with components called "Nozzels." Some "Nozzles" have multiple attributes called "TML" in this instance.  I'm try to determine how many "Nozzles" have multiple "TMLs".  The multiple "TMLs" is indicated by the "Brass Tag" and the "Nozzle" being the same info while "TML" column would list 01, 02, etc.

How would I create a conditional column with this info which would just say simply "multiple" if the "Brass Tag" value and "Nozzle Number" value are the same but "TML Number" has more than one entry value?

Thanks for the help.

[Mariusz · Accepted solution]

Hi @frank_fillingim 

Try this.

VAR x = COUNTROWS(
    CALCULATETABLE(
        YourTable,
        ALLEXCEPT(YourTable, YourTable[Brass Tag], YourTable[Nozzle Number])
    ) 
) > 1
RETURN 
IF( x, "multiple", "single" )

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.