I have some confusion about relationships between dimensions. We started working on the assignment, but I am confused about how to create the correct relationships. The first business question we need to answer is: Which product has the highest return, and why? We created a relationship between: Dim Product (Product ID) Returns (Return ID) Is this relationship correct? Then we created this measure: Total Return = COUNT(Returns[OrderID]) The result is 3200. After that, we tried to find the top returned product by applying this measure: Top Returned Product = TOPN( 1, ALL('Dim-product'[ProductName]), [Total Return], DESC ) But the result only shows the text "Top returned product" instead of showing the actual product name. Can someone guide us on how to create the correct relationships and which parameters we should use according to the assignment question? My suggestion: We should create a WhatsApp group for quick discussion whenever anyone faces a problem, so we can solve issues together. Drop your valuable thoughts.

Assignment Done ✅

While creating the first dashboard, the most time consuming part was creating dashboard.

I am Muhammad aftab. I have watched all the recorded sessions, and they were very comprehensive and informative. we gained a lot of knowledge and learned many useful Power BI techniques. Now we are waiting for the follow-up live session and are excited to attend it together with our batchmates. Personally, I really liked your teaching style. your method of explaining concepts was excellent and easy to understand. throughout the sessions, we several questions, and we will be posting them one by one n the community on a daily basis. Thank you for your time and effort dear Sir.❣️