return rate

[N00BPower]

Hi,

sorry for that noob-question 🙂

I got an table includiing "timestamp" "revenue"

Negativ Revenues = returns

I like to create a chart including the historical Return-rate

Calculating the Return-rate per day like:

Return-rate=Sum(negativ revenue)/Sum(positiv revenue)

Could you please help me how to do that?

Thanks a lot.

[Greg_Deckler · Accepted solution]

Sample data always helps. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Return Rate = 
  ABS(
    DIVIDE(
      SUMX(FILTER('Table',[Revenue]<0),[Revenue]),
      SUMX(FILTER('Table',[Revenue]>0),[Revenue]),
      0
    )
  )
      

But, you will probably want something like:

[N00BPower]

Thanks a lot Greg_Deckler that works. My next Question will be much more professional 👍

[parry2k]

@N00BPower try this, add following two measures

Total Sum = SUM ( Table[Amount] )

Return Rate = 
DIVIDE (
ABS ( CALCULATE ( [Total Sum], [Amount] < 0 ) ),
 ( CALCULATE ( [Total Sum], [Amount] > 0  )
)