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.
Hello,
I recently started using Power BI and I am having trouble getting the result I want.
My Data:
I have a dimension table containing information about airports, like name and location. I also have a fact table containing flights per month per year, for each airport. A diagram of the tables is below.
My Problem:
I want to calculate what percentage of a region’s flights occur at each airport in that region per month per year. Ultimately, I want to place this calculation in a chart.
I have been able to create a measure that calculates the percent of national flights that occurred in a region but haven’t been able to apply this to the airports within the region.
AtlanticFlights = CALCULATE(SUM(fFlights1[Flights]),Airports3[Region] = "Atlantic")
Any help would be very appreciated.
Thanks in advance.
Hi @BIstudent ,
I'm a little confused by your description. Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Share some data and show the expected result in a Table format. Do not bother about the final desired chart right now. First let's get the correct result in a Table. We can thereafter always switch the visual to any chart.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |