POWERBI. Request for help in retrieving data using DAX Query

[mhzd]

Hi, 

I need support in writing DAX Query. 

For context, below is the query I'm working on:

EVALUATE

VAR FilteredEmployees =

    FILTER(

        'All_Emp',

        'All_Emp'[Company] = "Comapny”

      )

VAR FilteredHIQMS =

    FILTER(

        'HIQMS',

        'HIQMS'[Days Overdue] >= 0

    )

VAR MatchedEmployeesHIQMS =

    CALCULATETABLE(

        SELECTCOLUMNS(

            FilteredEmployees,

            “User ID”, ‘All_Emp’[User ID],

            “User Initials”, ‘All_Emp’[User Initials],

            “Full Name”, ‘All_Emp’[pFull Name],

            “Company”, ‘All_Emp’[Company],

            “Days Overdue”, MAXX(FilteredHIQMS, ‘HIQMS’[Days Overdue]), -- Aggregate Days Overdue

            “Item Title”, FIRSTNONBLANK(‘HIQMS’[Item Title], BLANK()), -- Aggregate Item Title

            “Functional Manager”, FIRSTNONBLANK(‘HIQMS’[Functional Manager Name], BLANK())  -- Aggregate Functional Manager

        ),

        TREATAS(

            SELECTCOLUMNS(FilteredHIQMS, 'Initials', 'HIQMS'[Initials]),

            'All_Emp'[User Initials]]

        )

    )

RETURN

    MatchedEmployeesHIQMS

And here are the values it returns to me(avaliable in screenshoot - erros in output described below)

ERRORS: 
Days overdue - 1202 pops up everywhere(there should be different values) ;
Lack of any value in Item Title I Functional Manager columns(I know there should be values I've check this manually) ;
For each user the table returns me only one row, despite the fact that for multiple users it should return multiple values(several different Item Title can be assigned to one user - I know this, checked this manually as well).

Thank you very much in advance for your support!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...