Forum Discussion

devesqdeves's avatar
devesqdeves
Helper 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
Super User
2 years ago

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • lbendlin's avatar
    lbendlin
    Super 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
    Super User
    2 years ago
    FILTER(
        'DW FCTEndOfYearEndings',
        [FilterDateHCFACCurrentDate] = 1 ...
  • devesqdeves's avatar
    devesqdeves
    Helper 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?