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( SUMM...
Need Help
  • ABC11's avatar
    ABC11
    4 years ago

    This is sloved.

ABC11's avatar
ABC11
Resolver I
4 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
4 years ago

Just ignor this last reply I open up new topic.

Sorry for confusion