ADD filter to existing measure

[Ulal]

Hi Team, I have a measure,for this measure now i have to add an extra filter with MAX(MonthKey) column.

COUNTROWS(FILTER(ADDCOLUMNS(SUMMARIZE('SVDemo','SVDemo'[NationalIdNo],"Distinctpolicies", DISTINCTCOUNT('SVDemo'[PolicyTypeCd])), "policycount", [Distinctpolicies]), [policycount] =2))

Thak you

[Anonymous · Accepted solution]

Hi @Ulal ,

Please have a try.

measure =
VAR _1 =
    MAXX ( ALL ( 'SVDemo' ), 'SVDemo'[MonthKey] )
RETURN
    COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                SUMMARIZE (
                    'SVDemo',
                    'SVDemo'[NationalIdNo],
                    "Distinctpolicies", DISTINCTCOUNT ( 'SVDemo'[PolicyTypeCd] )
                ),
                "policycount", [Distinctpolicies],
                "amonthy", 'SVDemo'[MonthKey] = _1
            ),
            [policycount] = 2
        )
    )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.