Forum Discussion

mhzd's avatar
mhzd
New Member
1 year ago

POWERBI. Request for help in retrieving data using DAX Query

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!

1 Reply