Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bobpercy
New Member

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

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_0-1659788184755.png

 

15 REPLIES 15
bobpercy
New Member

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_0-1659872794258.png

bobpercy_1-1659872870030.png

 

@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_3-1659874638655.png

 

bobpercy_0-1659874478925.png

bobpercy_1-1659874538519.png

bobpercy_2-1659874570086.png

 

 

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

 

bobpercy_0-1659877794797.png

bobpercy_1-1659877903605.pngbobpercy_2-1659877950009.png

 


@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).

gauthamboppana_0-1659890883117.png


2) Calendar table to Expense table: One to many (Filter direction = Single( Calendar table filtering Expense table)

gauthamboppana_1-1659891147267.png





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

bobpercy_2-1659897477168.png

 

 

Trip Bill to Trip

bobpercy_1-1659897390926.png

 

 

 

Expense To Calendar

bobpercy_0-1659897156209.png

 

Logged Hours is coming from the Trip Bill table

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

Logged Hours is coming from the Trip Bill table

 

@bobpercy  -  Change the below cross filter direction to Single (Trip filters Trip Bill).

 

gauthamboppana_1-1659900515731.png

 

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  - Can you share the sample .pbix file?

 

Yes. How do I do that?

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

 

 JRAM.pbix

Same result. Still off. 

 

bobpercy_0-1659901549677.pngbobpercy_1-1659901608257.png

 

gauthamboppana
Solution Specialist
Solution Specialist

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 !

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors