Forum Discussion

Salvetti_01's avatar
Salvetti_01
Regular Visitor
1 year ago
Solved

Payroll Grouping Question

Sample Payroll Grouping Excel Hi everyone,   I could use some help with a report I'm trying to build to group employee salaries by specific groups. The link above is a sample data model I'm wo...
Need Help
  • Salvetti_01's avatar
    Salvetti_01
    1 year ago

    Thanks Ashish. Disconnecting the tables was helpful. In addition, some DAX was needed.

    Earning Amount =
    VAR SelectedGroup = SELECTEDVALUE(Groups[Group])
    VAR SelectedCostCenter = LOOKUPVALUE(Groups[Group Cost Center],Groups[Group], SelectedGroup)

    RETURN
    CALCULATE(
        SUM('Actual_Payroll'[Earnings Amount]),
        FILTER(
            Actual_Payroll,
            Actual_Payroll[Charged Cost Center] = SelectedCostCenter
            || Actual_Payroll[Home Cost Center] = SelectedCostCenter
        )
    )
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

Access Denied message.  In that PBi file, cclearly show the problem and the expected result.