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

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

Hi amitchandak - i have those measures but MS_%_Applied is actually calculating the individual % for the fee_category

 

I want to calculate the % Applied = (% Applied of BillingAmt)  + (% Applied of Gross)  i.e. 3.08+0.11= 3.19 into another column?? or where?

 

So the % applied = 3.19 (for both network_fee and stripe_fee)

 

Then the measure if([MS_%_Applied ] >.0205 , "Premium", "Not Premium") can be created.

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 ?