Forum Discussion
Sales total combine.
How you guy's find a combined total sales? I find Total sales for each of them but it's customers and drivers separated. how you combine them. adding new column like "Role" using dax( i don't really ...
rajendraongole1
Super User
Super UserHi dkbbr - you can create a new calculated table with combining the sales data for customers and drivers.
CombinedSales =
UNION(
SELECTCOLUMNS(
FILTER('Cmbine', NOT(ISBLANK('Cmbine'[CustomerPkId]))),
"Name", 'Cmbine'[CustomerName],
"Role", "Customer",
"Sale", 'Cmbine'[SaleAmount]
),
SELECTCOLUMNS(
FILTER('Cmbine', NOT(ISBLANK('Cmbine'[DriverPkid]))),
"Name", 'Cmbine'[DriverName],
"Role", "Driver",
"Sale", 'Cmbine'[SaleAmount]
)
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value"?