how to calculate with a measure instead of the calculated column i created

[CR7]

I have the following table "CADASTRO":

and i have a "CALENDARIO" table created with CALENDARAUTO, only with a date column.

In this calendario table , I create the following CALCULATED COLUMN :

QTDE_M = COUNTROWS(

    CALCULATETABLE('CADASTRO',

    FILTER('CADASTRO',

    'CADASTRO'[DATA_INSCRICAO2] <= 'CALENDARIO'[Date] &&

    'CADASTRO'[DATA_STATUS] > 'CALENDARIO'[Date] &&

     CADASTRO[STATUS]="M")))

How can I have the same result with a MEASURE ?

[CR7]

tHANKS FOR HELP

[v-zhangti · Accepted solution]

Hi, @CR7 

You can try the following methods.

Measure =
CALCULATE (
    COUNTROWS ( 'CADASTRO' ),
    FILTER (
        ALL ( 'CADASTRO' ),
        'CADASTRO'[DATA_INSCRICAO2] <= MAX ( 'CALENDARIO'[Date] )
            && 'CADASTRO'[DATA_STATUS] > MAX ( 'CALENDARIO'[Date] )
            && 'CADASTRO'[STATUS] = "M"
    )
)

Or:

Measure =
CALCULATE (
    COUNTROWS ( 'CADASTRO' ),
    FILTER (
        ALL ( 'CADASTRO' ),
        'CADASTRO'[DATA_INSCRICAO2] <= SELECTEDVALUE ( 'CALENDARIO'[Date] )
            && 'CADASTRO'[DATA_STATUS] > SELECTEDVALUE ( 'CALENDARIO'[Date] )
            && 'CADASTRO'[STATUS] = "M"
    )
)

Please try to see if you can get the results you expect.

Best Regards,

Community Support Team _Charlotte

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