Power bi : Segment can't filter a matrix due to the measure used for values

[EmericTms]

Hello, 

I would like your help regarding a configuration I cannot manage to fix.

I created some random data to better explain my problem. 

I have these two tables, they are related through the id of the first table :

And I would like to create the matrix below, where the segment "chapter" filters the lines (TDL) of the matrix.

And the measure that gives the matrix values should return : the max Score (1, 2 or 3) or 4 if the company doesn't have a score for the chapter (so if there is no lines in the table associating the chapter to the company), except if the company is "Tesla" and the chapter "1a" or if  the company is "Apple" and the chapter "5b", then it should return 5. 

Thanks to someone help, I could create the matrix with the right values. But with the measure used in the matrix, the segment "Chapter" can't filter the matrix to only show the lines (TDL) corresponding to the filtered chapter. (The filter chapter is coming from another disconnected table that I created to make the matrix work).

The tables and current measure are on this power bi :

powerbi test 

Does someone knows how I could solve this and make the filter work ? or have another way to achieve the result I want ?

Thank you.

[ahmedoye]

Hello, I have used this formula below, try it and if it works for you, kindly mark this as answer to allow anyone with similar challenges find the solution:

Measure 3 =

VAR CalcValue = CALCULATE(MAX(Tableau1[Score]), TREATAS(VALUES(DisconnectedTable[Chapter]), Tableau2[Chapter]))

VAR SelectedChapter = SELECTEDVALUE(DisconnectedTable[Chapter])

VAR SpecialCheck = OR(AND(SELECTEDVALUE(Tableau1[Company]) = "Tesla", SelectedChapter = "1a"),

                        AND(SELECTEDVALUE(Tableau1[Company]) = "Apple", SelectedChapter = "5b"))

VAR BlankCheck = ISBLANK(CalcValue)

VAR FinalCheck = AND(BlankCheck, SpecialCheck)

RETURN SWITCH(TRUE(),

                FinalCheck, 5,

                BlankCheck, 4,

                CalcValue)