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

This is the measure of "laatste transactie"

 

Laatste transactie: = MAX(History[EDATE])

 

I hope someone can help my

    • 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