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 |
|---|---|
| 58 | |
| 45 | |
| 31 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 75 | |
| 65 | |
| 46 | |
| 23 | |
| 22 |