Problem with countrows

[DavidWaters100]

Hi, I have the following Dax expression which counts how many times a reference appears within a table.  But I also have a column with 3 types of row (A, B C) and need to only count A.  I can't seem to figure out how to return the below count result but for only type A - for certain reasons I can just add the Type to the Concat reference.

Any help greatly appreciated!

thanks

COUNT =

VAR __CurrentRowID = MonthlyMovement[Concat]

RETURN

(COUNTROWS(

    FILTER(

        ALL(MonthlyMovement),

        __CurrentRowID = MonthlyMovement[Concat]

    )

)

)

[Greg_Deckler · Accepted solution]

COUNT =

VAR __CurrentRowID = MonthlyMovement[Concat]

RETURN

(COUNTROWS(

    FILTER(

        ALL(MonthlyMovement),

        __CurrentRowID = MonthlyMovement[Concat] && [Type] = "A"

    )

)

)

[DavidWaters100]

Thanks very much - not sure why I didn't think of that!

[Greg_Deckler]

Sometimes just takes a fresh set of eyes!