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.
I am trying to create a report that shows the total and past flight time for pilots for each upcoming trip. When I filter for upcoming trip dates it also filters out the total and past fight times. I have unsuccesfully tried to use and "All" or "AllExcept" filter in my measures but they have not worked. Here are my current measures.
Here is my model:
Thanks for the help.
1. What is the purpose of the bidirectional relationship? Should it not be unidirectional?
2. Why not have a separate dimension table with the names of the pilots and copilots only? Which one is the fact table in this model?
Can you share the pbix by any chance? Beware of confidential data.
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
The bidirectional relationships is required so that I can create a table of crew flying time by choosing a pilot from the FlightLegCrew table and get all the flight legs that pilot has flown from the FlightDataAnalysis table. The FlightDataAnalysis table has two columns for crew, Pilot and CoPilot. The same crew member could be the pilot on one flight leg and a copilot on another so I cannot sum total flight time by just using the FlightDataAnalysis table. So in that sense, the FlightLegCrew table is the fact table.
I am sorry, I am not allowed to share the pbix file.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |