Forum Discussion

Ronald123's avatar
Ronald123
Icon for Resolver III rankResolver III
9 years ago
Solved

Function calculate with true/false expression is not allowed

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?

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

4 Replies