Selecting a filter (the only value left in another column) in a dax formula

[mabu]

Hello Community 🙂 

I'm trying to calculate a benchmark for a given industry code; each company is only linked to one industry 

Thus, when selecting a company, it should take into account the company code, whilst calculating the average for the industry (found through the selection of a given company) 

The below return the average ACROSS industries (the filter in the end does not apply), where it should take into account IndustryCategory[IndustryCategoryTitle_1] in the filtering (calculation):

CALCULATE(AVERAGE(Employee[EmployeeSeniority]);ALL(Company);ALL(Employee[EmployeeJobTitle]);FILTER(IndustryCategory;IndustryCategory[IndustryCategoryTitle_1]<>""))

Any input to what this might look like in dax? (I've tried a variation of selectedvalues, crossfilter and values as well) but those guys return an error. 

Thank you! 

Br,

Mads

[v-yuezhe-msft]

@mabu,

What error message do you get using the above DAX ?

Please share sample data of your tables and post expected result here following the guide in this post:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

Regards,
Lydia

[mabu · Accepted solution]

Sorry - it was sorted out through changes in the cube. 

Thank you anyhow and I will remember the guidelines for my next inquiry. 

Br,

Mads

[v-yuezhe-msft]

@mabu，

Glad to hear the issue is solved. You can share detailed solution here, other members would benefit from the solution.

Regards,
Lydia