Matrix in PowerBi shows same values for each row

Hi MSiwek,
Thank you for the update.

The error occurs because the FILTER function in the Total Services measure references columns from multiple tables (Zmiany, SaxNames, Calendar), which isn’t allowed in a True/False expression. Let’s fix this by using variables to handle the multi-table logic.

Here’s the corrected measure:

Total Services =

VAR MinCalendarDate = MIN('Calendar'[Date])

VAR MatchingSaxNames =

    CALCULATETABLE(

        VALUES(SaxNames[UserId]),

        SaxNames

    )

RETURN

CALCULATE(

    COUNT(SAX[SERVICE]),

    FILTER(

        Zmiany,

        Zmiany[EmployeeId] IN MatchingSaxNames &&

        MinCalendarDate >= Zmiany[DateFrom] &&

        (ISBLANK(Zmiany[DateTo]) || MinCalendarDate <= Zmiany[DateTo])

    ),

    TREATAS(VALUES('Calendar'[Date]), SAX[SVCDATECREATED])

)

Please update the measure and test it in your visual. Ensure "Show items with no data" is enabled to display all employees.

If this helps, kindly consider marking this response as "Accept as Solution" and giving it a "Kudos" to assist other community members facing similar challenges.

Thanks.