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
abc_777
Solution Specialist
Solution Specialist

Relation issue

Hi,

 

I have following relation

abc_777_0-1686399078338.png

 

where invoice and Store ID concatanate with SSummar and Sales Table with many to one in both direction

abc_777_1-1686399161951.png

then i have bmcalendar with sales table many to one single direction 

abc_777_2-1686399243441.png

 

when i take invocie_dt from ssummary table only march 2023 to filter net_AMT i got correct result

abc_777_3-1686399298319.png

 but when i take march 2023 from bmcalendar table and filter i got incorrect result

 

abc_777_4-1686399378172.png

 

interesting this this is happened some month like march 2023, november 2022 etc. other than those most months are ok. so how i really identify the issue

 

 

I drill down and found that 29-03-2023 has issue. in my data view i have 4 invoises but in visual when i use bmcalendar is not reading one imoive which is invoice number INVOICE_NO = 0023032900009 and has Net_amt is 985

0023032900009
0023032900024
0023032900004
0023032900023

 

abc_777_0-1686403306182.png

 

so when i filter invoide_dt from ssummary table it has no issue but when filter using bmcalendar table it not getting one invoice. i checked this 0023032900009 is same as other 3 invoice rows and is in data view. but not showing in visual

 

abc_777_1-1686403515313.png

 

 

what could be the possibility issue for this specific day in month of calendar.  please help

 

thanks

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

what made you choose "both directions"?

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

what made you choose "both directions"?

Helpful resources

Announcements
Europe Fabric Conference

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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