Table not return the correct total of a measure

[Anonymous]

i created a measure to count the total number of orders a customer did on the months, but i saw the total is wrong. I need help to correct this total  (1+1+1+1+1+2+2 =9)

This is my measure

.Measure1 =

IF (

MAX ( 'Calendario1'[Date] ) <= EOMONTH ( TODAY (); -13 );

BLANK ();

IF (ISBLANK ( DISTINCTCOUNT ( fOrder[K_NumberOrder] ) );0;DISTINCTCOUNT ( fOrder[K_NumberOrder] )))

Thanks

[Anonymous]

Without seeing the actual data, you need to add in SUMX( Values( Date[Month]) to your measure. Maybe something like this, but more of a guess:

.Measure1 =
IF (
    MAX ( 'Calendario1'[Date] )
        <= EOMONTH (
            TODAY ();
            -13
        );
    BLANK ();
    IF (
        ISBLANK (
            DISTINCTCOUNT ( fOrder[K_NumberOrder] )
        );
        0;
        SUMX ( VALUES ( Date[Month]);
        DISTINCTCOUNT ( fOrder[K_NumberOrder] )
        )
    )
)

[Anonymous]

Hey @Anonymous ,  here is my  data 

https://1drv.ms/u/s!Apt7lzq2XcE5jCXGwG2vlblnXDOX

Thanks

[Anonymous · Accepted solution]

I was close, but this will work:

.Measure1 = 
SUMX( VALUES ( Calendario1),
    CALCULATE(
        IF (
            MAX ( 'Calendario1'[Date] ) <= EOMONTH ( TODAY (), -13 ),
            BLANK (),
        IF (
                ISBLANK ( DISTINCTCOUNT ( fOrder[K_NumberOrder] ) ),
                0,
                DISTINCTCOUNT ( fOrder[K_NumberOrder] )
            )
       )
    )
 )

[Anonymous]

Worked, thanks a lot @Anonymous