Forum Discussion

grantsamborn's avatar
grantsamborn
Icon for Solution Sage rankSolution Sage
3 years ago

Have you considered a calculated column?

cTotal_Salary = 
VAR _ID = TableName[ID]
VAR _Date = TableName[Date]
VAR _Result =
    SUMX(
        FILTER(
            ALL( TableName ),
            TableName[ID] = _ID
                && TableName[Date] = _Date
        ),
        TableName[Salary]
    )
RETURN
    _Result

If you use this column in a table or matrix, you might have to adjust the aggregation for the total line.

Let me know if this helps.

grantsamborn's avatar
grantsamborn
Icon for Solution Sage rankSolution Sage
3 years ago

Meghbajaj 

I made up some fake data and that usually worked.  I'm trying to figure out why there are cases that didn't work.

Is there any way you can come up with more sample data?