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...
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

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

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

Anonymous's avatar
Anonymous
Not applicable
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