Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Table 1: Dax Calender
- Full Date: All Dates in Format DD,MM,YYYY (from 2017 - 2020)
- Days (Short): Days associated with all dates, in format Mon, Tue, Wed, etc
Table 2: Library Archive
- Author ID: Strings, around 5k rows
- Creation Date: Date Format DD,MM,YYYY (from 2018 - 2019)
- Interacted With = IF ( ISBLANK ( COUNTROWS ( RELATEDTABLE ( 'Interactions' ) ) ), "Not Found", "Found" )
(Interacted With is a custom Column)
Table 3: Interactions
- Review ID: Strings, 10 rows total (each containing a unique and exact copy of an Author ID cell)
- Submission Date: Dates in Format DD,MM,YYYY (from 2019 - 2019)
This is what happens:
[Remove all Relationships]
[Remove all Relationships]
Someone, please help me! I would really like to submit this model soon, but I have no idea what's going wrong. This is how I built all of my relationships last year, and now this new Model view just won't work how I expect it to 😕
Can anyone figure out what's going wrong here?
Hi @StefanM ,
The new Model view didn't change anything in the way relationships work, they are just displayed in a different way, however the basic of the view that concerns the link is still the same:
(1) - Table with relation of One
(*) - Table with Relation of Many
> - Filtering from a single side view
<> - Filtering both ways
Are you sure that the previous models you made were with bothways filter?
Can you share an example of your data and expected result?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHiya MFelix! Ofc, no problem. I just created a mock report using some random figures following the example above for you.
The most curious note. It works when everything is a 1 < > 1 relationship.
When Library & Dax are 1 <>1, it all works fine.
So perhaps it's the custom column that isn't working then?
I was so sure this always worked for me in the past, but I fully take @MFelixs word as gospel when he says nothing has changed re: relationships. So now I need to find some way to cross filter these tables, so that the values of each is reflected in any other.
I am thinking something like creating a live modular key that updates as the spreadsheet is populated.
The previous system linked in the OP works for me with a direct relationship between two tables.
But it does not work with a relationship through another table.
Can you guys think of anything else?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |