data model issue

2 Topics

Help w SumX using calculated column (multiplication)
Hi all I have a data model which Im using to calculate costs in an excel data model. Each employee is assigned a % they are on a scrum team. I have the daily rate for each employee and multiply that by % to get the adjusted daily rate. When I sum this column implicitly or explicitly with a measure I am getting the incorrect total for each scrum team. I am assuming I need to use SumX to get the correct total per scrum team however I cannot get it to work. The adjusted daily rate column multiplies % by daily rate. I need to sum this column to show all the scrum team rates by team and employee. The subtotal rows for each scrum team are not displaying correctly but the employee rows are correct. AdjDailyRate:=SUMX(Scrum__W_Rates,SUM(Scrum__Rates[Adjusted Daily Rate])) Example: the highlighted cell should equal 14,996.25. Thank you
Solved
PowerPaul
3 years ago Place DAX Commands and Tips
974Views
0likes
3Comments
help with same user columns in same table
Hi there, Please i need help with how too target a problem like having two user names on the same table. I have an submitted and approved users that have the same data content for instance (please see table below). I also have a user table that gives me the data desciption like the names of these users however, in power bi i can only link the users table to one column (with an active relationship) to my data table. And I linked it to my "submitted user" column which gives me a view as below! Problem: I want to be able to create a table view where I can only have one user column with their respective metrics instead of user submitted and user approved seperately. Please see below of sample data view. sample data table: submitted user approved user entries approved 1001 1001 4 4 1002 1001 5 5 1003 1005 6 5 1004 1010 7 7 1005 1005 8 5 user table (liked to the above sample data table) user Name 1001 Ann 1002 Peter 1003 Christi 1004 Paul 1005 Dan 1010 Will Expected results (would like a single user column with its various aggregates as shown): user name entries approved 1001 Ann 4 9 1002 Peter 5 0 1003 Christi 6 0 1004 Paul 7 0 1005 Dan 8 10 1010 Will 0 7 Is this possible to archieve? and if so please help, thank you.
Solved
yve214
4 years ago Place DAX Commands and Tips
657Views
0likes
2Comments