Forum Discussion

Kraftfood's avatar
Kraftfood
Helper I
3 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 ...
Need Help
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
Helper 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 😕