Forum Discussion

mohsenask's avatar
mohsenask
Icon for Helper II rankHelper II
4 years ago
Solved

Total two rows for a measure

v-angzheng-msft      All_Fees [fee_category] All_Payouts [charge_id] [billing_amount] [gross] MS_GROSS = sum(All_Payouts[gross]) MS_BillingAmt = (sum((All_Fees[billing_amount]))) ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mohsenask ,

     

    You could use SUMX() function to get the sum of measure.

    For example:

     

    Measure 4 = SUMX(ALL('Table'),[Measure 3])

     

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mohsenask , You can not have column now you can measure

Both should be measure

M1 =

[% Applied of BillingAmt] + [% Applied of Gross]

 

Or

AverageX(values(Table[Charge id]) ,[% Applied of BillingAmt] + [% Applied of Gross]  )

mohsenask's avatar
mohsenask
Icon for Helper II rankHelper II
4 years ago

amitchandak 

M1 =

[% Applied of BillingAmt] + [% Applied of Gross]

 

are these two new measures to create and then sum them into M1 ?