Forum Discussion

Kraftfood's avatar
Kraftfood
Icon for Helper I rankHelper I
4 years ago

Filter issue between tables - 100% everywhere

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!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Kraftfood
      Icon for Helper I rankHelper I
      3 years ago

      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 😕