Forum Discussion
Matrix in PowerBi shows same values for each row
There is no filter flow from your Zimiany table to your SAX table so you will not get a proper filter contect if you use the "Nazwa grupy" from "Zmiany" and the measure built off of SAX.
Without knowing your datamodel it is difficult to give you the best path forward. With that said I would default to Roche’s maxim and say you probably should look at doing some upstream work.
Please mark this post as solution if it helps you. Appreciate Kudos.
I can make a direct connection between "Zmiany" and "SAX" because I can improve my sql query or merge data in PQ to have also column SaxName in "Zmiany" table but what about Employees and Presence States table? If I made direct connection between "Zmiany" and "SAX" "SaxNames" wouldn't be used and could be delated.
andrewsommer i made a sample of my data.
SAX:
SVCDATECREATED SERVICE SVCCREATEDBY 25.03.2025 NAME OF SERVICE 1 SWK 01.03.2025 NAME OF SERVICE 2 KWS 14.03.2025 NAME OF SERVICE 1
SWK Połączenie:
SVCCREATEDBY SWK KWS SaxNames:
Saxname UserId SWK 1 KWS 2 Zmiany:
EmployeeId Nazwa grupy 1 Dep 1 2 Dep 2 Employees:
EmployeeId NAME AND SURNAME 1 MICHAEL TEST 2 JACOB TEST PresenceStates
EmployeeId WorkinHours Date 1 8 01.01.2025 2 8 02.01.2025 Would this be helpful?
