Forum Discussion

ABC11's avatar
ABC11
Resolver I
4 years ago
Solved

Measure total incorrect

Hello TO all
This measure is working fine.
 
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)
)
 
I creatred another measure
 
LINECOST divided by EQUIPHRS =
DIVIDE(
    SUM('LEM FACT with query'[LINECOST]),
    SUM('LEM FACT with query'[EQUIPHRS])
)
 
 
One more measure
 
LINECOST divided by EQUIPHRS x More_than_170hrs =[LINECOST divided by EQUIPHRS] * [More_than_170hrs]
This last measure row wise  multiple is correct but coumn  total is not correct?
Please, help me to slove this
Thanks
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ABC11 , You need force row or row context

     

    Sumx(('LEM FACT with query', [LINECOST divided by EQUIPHRS] * [More_than_170hrs])

     

    or

     

     

    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]
    ),[LINECOST divided by EQUIPHRS] * [More_than_170hrs] )

  • ABC11's avatar
    ABC11
    4 years ago

    Thanks Amitchandak

    Sumx(('LEM FACT with query', [LINECOST divided by EQUIPHRS] * [More_than_170hrs])- this was giving me total but row level giving me 0 which don't work for me.

     

    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]
    ),[LINECOST divided by EQUIPHRS] * [More_than_170hrs] )

     

    This one worked for me.

    Thanks Lots

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    ABC11 , You need force row or row context

     

    Sumx(('LEM FACT with query', [LINECOST divided by EQUIPHRS] * [More_than_170hrs])

     

    or

     

     

    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]
    ),[LINECOST divided by EQUIPHRS] * [More_than_170hrs] )

  • ABC11's avatar
    ABC11
    Resolver I
    4 years ago

    Thanks Amitchandak

    Sumx(('LEM FACT with query', [LINECOST divided by EQUIPHRS] * [More_than_170hrs])- this was giving me total but row level giving me 0 which don't work for me.

     

    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]
    ),[LINECOST divided by EQUIPHRS] * [More_than_170hrs] )

     

    This one worked for me.

    Thanks Lots