The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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]))