Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😕
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |