Forum Discussion

devesqdeves's avatar
devesqdeves
Icon for Helper II rankHelper II
2 years ago

Aggregate column values per Client Id in a matrix

Hello! I am having a hard time dealing with this problem, really hope that someone can help me out. -------------------------------------------------------------- Main goal is to be able to have a...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
FILTER(
        'DW FCTEndOfYearEndings',
        [FilterDateHCFACCurrentDate] = 1 ...
devesqdeves's avatar
devesqdeves
Icon for Helper II rankHelper II
2 years ago

lbendlin But thats what i have in the measure , 

Measure_=

CALCULATE(
    COUNTROWS('DW FCTEndOfYearEndings'),
    FILTER(
        'DW FCTEndOfYearEndings',
        [FilterDateHCFACCurrentDate] = 1 &&
        NOT(
            CONTAINS(
                'DW FCTEndOfYearEndings',
                'DW FCTEndOfYearEndings'[CandidateId],
                CALCULATE(values('DW LeaveDayDim'[CandidateId]),FILTER('DW LeaveDayDim',[FilterDateLeavesCurrentDate]=1))
            )
        )
    )
).
What should i do differently?