Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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!
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
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 😕
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |