Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
i have relation like these. In table projectdata I canuse related to salesName but I cannot use related to projectsubdata (I try to typing but it show nothing )
And second problem
if I related to userdata- sales it can related but show nothing.
thank
Hi, @Anonymous
You need to follow the star schema or snowflake schema in your data model. In your case you probably have more than 1 fact tables. In order to get correct results it is good to follow it. You can use LOOKUPVALUE instead of RELATED but this will not be a solution and maybe will cause some issues with data.
Proud to be a Super User!
@Anonymous , Based on what I got. Related can only be used from 1 side to many side. You can create new column on Many side .
You can try relatedtable for 1 side
example
sumx(relatedtable(projectData]),[Est Fee])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |