Date Slicer - works on one column but not on the other

[bobpercy]

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. 

[bobpercy]

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. 

[gauthamboppana]

@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 !

[bobpercy]

@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]

@gauthamboppana See below for the changes suggest below in this configuration. 

[gauthamboppana]

@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 !

[bobpercy]

@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

[bobpercy]

Logged Hours is coming from the Trip Bill table

[gauthamboppana]

@bobpercy  - Which table you are using to calculate the Logged Hours measure?

[bobpercy]

Logged Hours is coming from the Trip Bill table

[gauthamboppana]

@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 !

[gauthamboppana]

@bobpercy  - Can you share the sample .pbix file?

[bobpercy]

Yes. How do I do that?

[bobpercy]

I really appreciate your help. Not sure if this is what you are asking for. 

 JRAM.pbix

[bobpercy]

Same result. Still off. 

[gauthamboppana]

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 !