Dax help

[Timbuktu7]

Hello World,

I have two pics here. One in excel (blue color) and anothetr in Power Bi.  I have created a matrix in Power Bi with age category and transactions. 

Now I want to calculate the sucess rate . The formula that I used in Excel is : Sum(Total Transactions/Total Past Dues 1-30 Days)*100%) . Same with the remaining 3 . How do i do same in power bi?
Please help

[v-rzhou-msft · Accepted solution]

Hi @Timbuktu7 ,

I think you can try code as below to create a measure.

Payment success Rate =
VAR _Total =
    SUMX ( ALLSELECTED ( 'Table' ), 'Table'[Transactions] )
VAR _Transactions =
    CALCULATE ( SUM ( 'Table'[Transactions] ) )
RETURN
    DIVIDE ( _Transactions, _Total )

My Sample:

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[A_Ben_Chaoued]

var Total_transaction = sum(Transaction) return

rate = ( Transaction / Total_transaction ) * 100

return rate

I hope that help you, good luck 🙂