Counting the results of a DAX Measure

[jonclay]

Hello all,

I'm trying to count how many times a MM/YYYY (date) appears that has been calculated via a DAX Measure.

The following Measure looks through the payment table and looks at all the rows where the status is paid. It then calculates the latest paid date per customer (the table is linked to the contacts table):

Cancelled Yr & Month Column =

MAXX (

    FILTER (

        payment,

        payment[status] = "Paid"

    ),

    payment[dateofpayment]

)

The tabled result looks something like this:

I am then trying to find how many times each MM/YYYY combination appears. So, in the example above, 10/2008 would be 2 and 09/2008 would be 1.

How could I do this please? All attempts at using a Calculated Column and another Measure have failed me so far!

Many thanks
Jon

[ray_aramburo · Accepted solution]

Try using some inspiration from this post.

Usually this gets done with SUMX.