Forum Discussion
Helper IITotal two rows for a measure
All_Fees
[fee_category]
All_Payouts
[charge_id]
[billing_amount]
[gross]
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
7 Replies
- amitchandak
Super User
mohsenask , I think these should work
MS_GROSS = sum(All_Payouts[gross])
MS_BillingAmt = (sum((All_Fees[billing_amount])))
MS_%_Applied = [MS_BillingAmt]/[MS_GROSS]Then you can have a measure
if([MS_%_Applied ] >.0205 , "Premium", "Not Premium")
In case you need that as a filter explore bucketing
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
mohsenaskHi 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
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
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
