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.

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

amitchandak 

To make myself clearer, these are two records for ONE charge ID. So one unique ID has two records. I want to calculate the total of the MS_%Applied for the two records for each charge_ID. There could be more rows for each charge ID too

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

    amitchandak v-angzheng-msft 

     

    Need to identify whether premium or not based on the total of MS_%_Applied for the two rows that belong to ONE charge_ID