data model issue

3 Topics

Many to many cardinality causing issue to open PBIX in Power Bi reporting Server
I have a PBIX whose data set has many to many relationship within the tables. I have created it in normal power BI desktop app. When I am trying to open the same PBIX on Power BI desktop for reporting server , I am getting an error : "This file uses many to many relationships or a composite model which combines DirectQuery sources and/or imported data. These models arent currently supported in Power BI Report Server". Please help.
Anonymous
3 years ago Place Report Server
18KViews
2likes
13Comments
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
976Views
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