How to get a names based on existing measure

[Anonymous]

Jolly Day,

This seems like a very simple thing to get but I am new to Power BI and can't quite get it. I have a measure that returns the lowest counts based off of Entry type. I need to also add the names of the lowest to my Matrix. 
Here is the measure already created to grab the value. I need the Full Name based off of that value from the System_Users table

Least COUNT =

VAR FilteredTable =

    FILTER ( System_Users, [Sum Audits and Entries] <> 0 )

RETURN

    CALCULATE (

        Audit[Sum Audits and Entries],

        FILTER (

            FilteredTable,

            RANKX ( FilteredTable, [Sum Audits and Entries],, ASC, DENSE ) = 1

        )

    ) + 0

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

Table1：

Table2：

Here are the steps you can follow：

1. Create measure.

Name1 =
MAXX(
    FILTER(ALL(Table1),
    [Job Entry]=[Least COUNT]),[Full Name])

Name2 =
MAXX(
    FILTER(ALL(Table1),
    [Job Audit]=[Least COUNT]),[Full Name])

Name =
SWITCH(
    TRUE(),
    MAX('Table2'[Entry Type])="Job Audit",[Name2],
    MAX('Table2'[Entry Type])="Job Entry",[Name1])

2. Result:

Best Regards,

Liu Yang

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