Solved: Select a Value with 2 filters

DiePic · ‎10-25-2022

Hi all,
I need to find 1 value in a table with more filters

This is my table

I need to find the mail filtering name & level

Can somebody help me with dax?
thanx in advance

Greg_Deckler · ‎10-25-2022

@DiePic Measure = MAXX(FILTER('Table',[name] = "John" && [level] = 1),[mail])

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎10-25-2022

@DiePic Measure = MAXX(FILTER('Table',[name] = "John" && [level] = 1),[mail])

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

DiePic · ‎10-25-2022

thank you very much @Greg_Deckler

Select a Value with 2 filters