Measure to show equivalent value if the parent table is filtered

[olimilo]

I'm trying to display a single value based on a parameter if the parent table is filtered to just one value (using drillthrough to page) . We have 2 tables, AuditorData and Qualification, 1:M joined by a common ID column.

AuditorData

ID		Name
1		John Doe
2		Jane Doe
3		Jim Doe

Qualification

ID		Qualification	Level
1		Qual A		Lead
1		Qual B		Lead
1		Qual C		Sub
2		Qual B		Sub
2		Qual C		Sub
3		Qual A		Lead
3		Qual B		Sub

Previously, I am using the measure below to do just that however it is no longer working properly, where if a AuditorData[Name] has a matching record in a specific Qualification[Qualification], it should show the corresponding Qualification[Level] - now it is only showing blanks or "Not Certified" if there are no matches. Was there a change in how this works or is there a different solution to this?

Measure = IF(HASONEVALUE('AuditorData'[Name]),
        IF(
            CONTAINS('Qualification', 'Qualification'[Qualification], "Qual A"), 
            MIN('Qualification'[Level]),
            "Not Certified"
        ),
        "-"
    )

[Deku · Accepted solution]

Your measure isn't taking the level for the specific Qualification, need to filter by it

Measure = 
var qualLevel = 
   CALCULATE( 
      MIN('Qualification'[Level]),
      'Qualification'[Qualification] = "Qual A"
   )
var result =
   IF( ISBLANK( qualLevel ), "Not Certified", qualLevel )
RETURN
IF(HASONEVALUE('AuditorData'[Name]), result , "-")

[olimilo]

Thanks, this worked for me