Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
var Total_transaction = sum(Transaction) return
rate = ( Transaction / Total_transaction ) * 100
return rate
I hope that help you, good luck 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |