Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have two tables Order Table and Returns Table, I want to calculate return rate using of DAX
@PBIBALU , Assume you have common dimensions like Date, Order, Geography , Article/Item , customer etc
You can create a new measure like
divide( sum(Return[Qty]), sum(Order[Order Qty]))
or
divide( Count(Return[Qty]), Count(Order[Order Qty]))
| User | Count |
|---|---|
| 54 | |
| 41 | |
| 28 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 73 | |
| 59 | |
| 39 | |
| 22 | |
| 21 |