Measure based on two slicers over the same column

Hi nogarr 

If i understand you correctly,

e.g:

there are two slicers-

Project->Pro_1,        Industry->machinery

Project Score->scores of Pro_1

Benchmark Score->scores of machinery

If so,

First create two table

industry = VALUES(Table_1[Industry])

project table = VALUES(Table_1[Project])

i create measures using "sum", you can create your measures by replacing "sum" with "average"

Project Score = calculate( SUM(Table_2[Score]),FILTER(Table_2,Table_2[Project]=SELECTEDVALUE('project table'[Project])))

Benchmark Score = calculate(SUM(Table_2[Score]),FILTER(Table_1,Table_1[Industry]=SELECTEDVALUE(industry[Industry])))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.