Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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 cal...
  • Anonymous's avatar
    Anonymous
    7 years ago
    [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.

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

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's avatar
    Anonymous
    Not applicable
    7 years ago
    [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.