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

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