Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Kraftfood
Helper I
Helper I

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!

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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:

Kraftfood_0-1663225185865.png

See results with your measure:

Kraftfood_1-1663225200803.png

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 😕 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.