Error+Message%3A+MdxScript(Model)+(7%2C+138)+Calculation+error+in+measure

[Anonymous]

I need urgent help. I am  new user who is struggling with an error message shown below:

Error+Message%3A+MdxScript(Model)+(7%2C+138)+Calculation+error+in+measure

This comes when i write a calculate measure with a filter that is TRUE/FALSE type. 

Can someone rescue me? Below is the measure;

Prog Stock value(Expired & Closed) = ( SUMX( FILTER('Current Stock Report','Current Stock Report'[SOF Status]="SOF Closed"||'Current Stock Report'[SOF Status]="SOF Expired"||'Current Stock Report'[Prog / Admin Stock]="False"), ('Current Stock Report'[TIM Stock Value ($)]) ))

[Anonymous]

[Prog Stock Value (Expired & Closed)] =
    SUMX (
        FILTER (
            'Current Stock Report',
            
            'Current Stock Report'[SOF Status] = "SOF Closed"
                || 'Current Stock Report'[SOF Status] = "SOF Expired"
                || NOT ( 'Current Stock Report'[Prog / Admin Stock] )
        ),
        'Current Stock Report'[TIM Stock Value ($)]
    )

You cannot mix data types. If something is logical (False) you cannot equate it to a string ("False").

Best

Darek

[Anonymous]

Thank you Darek. 

Then I need your suggestion. For below, I need to calculate the sum of TIM stock Value 

'Current Stock Report'[TIM Stock Value ($)]

but only filter out what is 'False' in

( 'Current Stock Report'[Prog / Admin Stock] 

 The later is a true False data type.

Any suggestion?

[Anonymous · Accepted solution]

[TIM Stock Value] =
	CALCULATE(
		SUM ( 'Current Stock Report'[TIM Stock Value ($)] ),
		'Current Stock Report'[Prog / Admin Stock] -- this only keeps the TRUE values visible
	)

Best

D.