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.
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 need extra column)
Date | CustomerPkId | CustomerName | DriverPkid | DriverName | SaleAmount |
24/01/01 | 1001 | Jhon | 2001 | Brain | 1000 |
24/01/02 | 1002 | jon | 2002 | Brown | 1250 |
24/01/02 | 1003 | jin | 2001 | Brain | 4502 |
24/01/03 | 1002 | jon | 2003 | Tom | 12515 |
24/01/04 | 1001 | jhon | 2004 | Toms | 1412 |
I wanna look like this after writing DAX :
Name | Role | Sale |
Jhon | Customer | 2412 |
Brain | Driver | 5502 |
Hi @dkbbr ,
Based on the description, @rajendraongole1 the response provides the desired results. It should be helpful to you.
If you have solved the problem, please please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Wisdom Wu
Hi @dkbbr - you can create a new calculated table with combining the sales data for customers and drivers.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value"?
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |