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.
Date slicer by year, quarter, month when select 2022 on Logged Hours (flight) is correct, but on Invoice Total W/O Tax it is not correct. The amount in Invoice Total W/O Tax is calulating the total in each line item for the entire data set and should be for the year selected. example: N451A LLC should be $635,663 for Invoice Total W/O Tax not $804.854 and Logged Hours (Flight) = 312.35 is correct.
Thank you for your assistance. I am a early user of Power BI.
I dont have a DAX fomula on the Total W/O Tax. I get the same number if I use the DAX sum formula. As to the JRAX and Date, I dont have a direct relationship between the two. I am using the TRIP as my center. JRAX and TRIP are connected by Many to Many - Both.
@bobpercy Thanks for the screenshots. Make the changes to the relationships as below.
1) Calendar table to Trip table: One to many (Filter direction = Calendar table filtering Trip)
2) Trip table to JRAX table: Many to many (Filter direction = Trip table filtering JRAX table)
Let me know if this works.
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
@gauthamboppana we are making progress. Just not exactly correct just yet.
N451A should read Invoice Total W/O Tax $635,663.12 (correct), (Logged Hours Flight) 312.35 (not correct)
N753A should read Invoice Total W/O Tax $333,132 (not correct), (Logged Hours Flight) 311.21 (not correct)
@bobpercy - That's good to hear. Can you let me know from which table the Logged hours is calculated? I suspect again the same issue with the relationships.
Make the below changes and see if it works.
1) Below relationships, change the relationships to One to Many and the filter direction to Single (Trip table to filter the otehr tables).
2) Calendar table to Expense table: One to many (Filter direction = Single( Calendar table filtering Expense table)
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
@gauthamboppana The relationships are not letting me change from Many to Many to One to many. Do they all need to be connected to the same field ie aircraft or trip number or date?
Trip to Flight
Trip Bill to Trip
Expense To Calendar
Logged Hours is coming from the Trip Bill table
Logged Hours is coming from the Trip Bill table
@bobpercy - Change the below cross filter direction to Single (Trip filters Trip Bill).
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
Yes. How do I do that?
Same result. Still off.
Hey @bobpercy - what is the DAX formula you used fr calculating Invoice Total W/O Tax? Also, can you check if the relationship between te date table and the Invoice Total W/O Tax table is active?
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
User | Count |
---|---|
43 | |
25 | |
22 | |
20 | |
17 |
User | Count |
---|---|
54 | |
45 | |
24 | |
21 | |
21 |