Creating relationship problem in PowerBi

Hello Angiee ,

Your many to many relationship is not active. You might used dax formula USERELATIONSHIP to calculate or active it. However, I would recomment create detail Dim tables to implement glaxy schema for your case. I'm sure you rename more suitable for your DimTable(Mine is just examples) such as DimTicket table that includes Ticket ID and relative columns, DimEscalatio table that includes Escalation ID and relative columns, DimOppurnity table that includes Oppurtunity ID and relative columns and more...  That is best practice for data modelling.

But what I don't understand is you want to get deal value(I couldn't see in the image. You mean Count row etc?) where is F_SCC_Ticket_and_Inquiries and includes Oppurnity ID. From F_Escalations table what would you like to test?Could you explain a bit more? I'm a bit confused that you'd like to calculate.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |