DAX Help needed

[NaCl-y]

Hello all,

I have a problem with the DAX formula. I tried to see where my logic is wrong but i cannot find it. The formula is the following, 

LPRD In Advance = CALCULATE(COUNTA(SAP_Transaction_ZP26[LPRD]),
 FILTER(SAP_Transaction_ZP26,
 SAP_Transaction_ZP26[PDCL].[MonthNo] = MONTH(TODAY()) && 
 SAP_Transaction_ZP26[PDCL].[Year] = YEAR(TODAY()) &&
 SAP_Transaction_ZP26[LPRD] < SAP_Transaction_ZP26[PDCL]),
 SAP_Transaction_ZP26[LPRD] <> DATE(1900,1,1)) + 0

It follows this data table.

On my Dashboard, i have these

In the formula, I specifically said to not include the date of 1900/01/01 of LPRD, however it counts it. "LPRD In Advance" should be 2 instead of 3. 

Thanks in Advance!

[v-yulgu-msft · Accepted solution]

Hi @NaCl-y,

Please pay attention to the highlighted part.

LPRD In Advance =
CALCULATE (
    COUNTA ( SAP_Transaction_ZP26[LPRD] ),
    FILTER (
        SAP_Transaction_ZP26,
        SAP_Transaction_ZP26[PDCL].[MonthNo] = MONTH ( TODAY () )
            && SAP_Transaction_ZP26[PDCL].[Year] = YEAR ( TODAY () )
            && SAP_Transaction_ZP26[LPRD] < SAP_Transaction_ZP26[PDCL]
            && SAP_Transaction_ZP26[LPRD] <> DATE ( 1900, 1, 1 )
    )
)
    + 0

 

Regards,

Yuliana Gu

[Greg_Deckler]

Any reason you didn't "and" that condition to your other conditions?

[NaCl-y]

If you are talking about the  SAP_Transaction_ZP26[LPRD] <> DATE(1900,1,1), it is because that gives me an error shown below. 

[Greg_Deckler]

Try changing your <> to >