topic How to get a names based on existing measure in DAX Commands and Tips

How to get a names based on existing measure

Anonymous — Wed, 28 Sep 2022 16:05:49 GMT

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

Re: How to get a names based on existing measure

Anonymous — Thu, 29 Sep 2022 02:12:00 GMT

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