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

3 Replies

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