Filter issue between tables - 100% everywhere

[Kraftfood]

Hello, I have an issue between 2 tables within the same model. I am following a star schema and the 2 tables are not the central ones.

See below links to the Excel base table and the BI I'm working on. If you click on "Germany" from the right table (that shows Ratio Ticket / staff per country), the results in the left table is 100% everywhere for Germany. 

As of now I am setting the cross filter direct as single in order to block the filtering between tables and to avoid this issue but I would like to obtain the correct figures.

Does anyone have an idea of how to do that? I tried with the crossfilter DAX formula but did not succeed.

Do not hesitate to ask questions

Please see links to the power bi example.

Power BI: https://1drv.ms/u/s!AkGwzt_UiPRCg3DqEgmQkIJQZMVm?e=STjAnm

Excel Base: https://1drv.ms/x/s!AkGwzt_UiPRCg28GaAM8tKuKPAEQ?e=RvQAG0

Thanks in advance!

[Anonymous]

Hi @Kraftfood,

You can try to use the following formula if it is suitable for your requirement:

% nb employee used tickets = 
DIVIDE (
    SUM ( Staff[Staff raised ticket?] ),
    CALCULATE (
        COUNTA ( Staff[Name] ),
        ALLSELECTED ( Staff ),
        VALUES ( Staff[Country] )
    )
)

Regards,

Xiaoxin Sheng

[Kraftfood]

Hi Xiaoxin, thanks for your answer! However using your measure, the results are different from the previous one and incorrect... See First results with my measure:

See results with your measure:

Moreover, if I select germany from another tible, the results is 100% splitted between the different grades, which is not what I wanted either... 

Not sure what to do here 😕