Function calculate with true/false expression is not allowed

[Ronald123]

I have the follow warning: A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Whit this measure:

Cumulative Supply =
CALCULATE (
SUM ( 'Stock'[UNIQUE] );
FILTER (
ALLEXCEPT ( 'Stock'; 'Stock'[GRPCODE] );
'Stock'[DATEPURCH] <= MAX( 'Stock'[DATEPURCH] )
) ;
'Stock'[Datumverkoop:] = BLANK ()
)
-
CALCULATE (
SUM ( 'Stock'[UNIQUE] );
FILTER (
ALLEXCEPT ( 'Stock'; 'Stock'[GRPCODE] );
'Stock'[DATEPURCH] <= MAX( 'Stock'[DATEPURCH] )
) ;
'Stock'[Datumverkoop:] <> BLANK ()
)

 -------------------------------------------------------------------------------

Datumverkoop: = CALCULATE([Laatste transactie:];
Stock[Custom]="geretouneerd")
+CALCULATE([Laatste transactie:];Stock[Custom]="vernietigd")
+CALCULATE([Laatste transactie:];Stock[Custom]="verkocht")
+CALCULATE([1e transactie transactie:];Stock[Custom]="bemanning")
+CALCULATE([Laatste transactie:];Stock[Custom]="gestolen")
+CALCULATE([Laatste transactie:];Stock[Custom]="resource")

The measure datumverkoop: has the format date, what is goning wrong?

[Ronald123]

This is the measure of "laatste transactie"

Laatste transactie: = MAX(History[EDATE])

I hope someone can help my

[Anonymous]

This help?

https://msdn.microsoft.com/en-us/library/dn727121.aspx

[Ronald123]

@Anonymous Not at all. I kown the problem but i dont know the solution? Can you help my to change the measure?

[Anonymous · Accepted solution]

@Ronald123,

Create your measure using the following DAX instead.

Cumulative Supply =
CALCULATE (
SUM ( 'Stock'[UNIQUE] );
FILTER (
ALLEXCEPT ( 'Stock'; 'Stock'[GRPCODE] );
'Stock'[DATEPURCH] <= MAX( 'Stock'[DATEPURCH] )
) ;
FILTER('Stock';'Stock'[Datumverkoop:] = BLANK ())
)
-
CALCULATE (
SUM ( 'Stock'[UNIQUE] );
FILTER (
ALLEXCEPT ( 'Stock'; 'Stock'[GRPCODE] );
'Stock'[DATEPURCH] <= MAX( 'Stock'[DATEPURCH] )
) ;
FILTER('Stock';'Stock'[Datumverkoop:] <> BLANK ())
)

Regards,
Lydia