Forum Discussion

ABC11's avatar
ABC11
Resolver I
4 years ago
Solved

Matrix Measure if condition calculation

Hello,
I would like to have condition - if sum of equipment hrs is >179 then display otherwise put 0(do not want to see nagative)
I am getting error. Please, help me here
 
Diffe =
sumx(
SUMMARIZE(
'LEM FACT with query',
'LEM FACT with query'[VENDOR_NAME],
'LEM FACT with query'[CTR#],
'LEM FACT with query'[WORKDATE].[Year],
'LEM FACT with query'[WORKDATE].[Quarter],
'LEM FACT with query'[WORKDATE].[Month],
'LEM FACT with query'[EQUIPNUM],
'LEM FACT with query'[VENDEQUIPUNIT],
'LEM FACT with query'[EQUIPRATETYPE]
),

if(CALCULATE(SUM('LEM FACT with query'[EQUIPHRS])>179)),SUM('LEM FACT with query'[EQUIPHRS])-179),0)
)
 
 
Thanks lots
Need Help

3 Replies

    • ABC11's avatar
      ABC11
      Resolver I
      3 years ago

      Hello TO all

      In this  measure I am getting row level sum correct but column total incorrect.

      Please, help me

      More_than_170hrs =
      sumx(
      SUMMARIZE(
      'LEM FACT with query',
      'LEM FACT with query'[VENDOR_NAME],
      'LEM FACT with query'[CTR#],
      'LEM FACT with query'[WORKDATE].[Year],
      'LEM FACT with query'[WORKDATE].[Quarter],
      'LEM FACT with query'[WORKDATE].[Month],
      'LEM FACT with query'[EQUIPNUM],
      'LEM FACT with query'[Vendequipunit_Combine],
      'LEM FACT with query'[EQUIPRATETYPE]
      ),

      if(CALCULATE(SUM('LEM FACT with query'[EQUIPHRS])>170),CALCULATE(170-sum('LEM FACT with query'[EQUIPHRS])),0)
      )
       
      Thanks
      • ABC11's avatar
        ABC11
        Resolver I
        3 years ago

        Just ignor this last reply I open up new topic.

        Sorry for confusion