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

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.