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

You are trying to use a measure as a table filter.  You need to first add that measure to each row of the table (or to an aggregation) before you can filter on it.

  • 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?