Maximum Churned Job Title

Question

I am analyzing HR attrition data and trying to make a card visualize the name of the most-churned job title using Calculate (Max). Still, it returns the maximum job title alphabetically instead of ignoring the filters.

MaxChurnedJob = CALCULATE(MAX('HR-Employee-Attrition'[Job Title]),FILTER('HR-Employee-Attrition',[Churned Employees] = MAXX('HR-Employee-Attrition',[churned Employees])))

Answer 1

That's a DAX query and absolutely nothing to do with SQL Server; the tag you used.

It's Power BI and that isn't supported here opn Question&Answer.

Post on a more related forum => https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi