User
Write something
Pinned
May 23 β€’Β 
Updates
Important
Welcome to the Data Professional Community. Please join our WhatsApp channel becuase all the important updates, voice notes and meeting links will be posted directly in the Whatsapp Channel. https://whatsapp.com/channel/0029VbDDZsS0rGiNsiemRp0m
Just Build an Overview of Sales
The data which tells the story leads to Sound Decision
Just Build an Overview of Sales
Update your profile
πŸ“’ Everyone, please update your profile with the following information: πŸŽ“ Education πŸ’Ό Current Role/Occupation πŸ“ˆ Years of Experience πŸ› οΈ Skills & Tools (Excel, SQL, Power BI, Python, etc.) Having this information in your profile will help me and other members understand your background and provide more relevant guidance, feedback, and support throughout your learning journey.
Confusion about relationships and Measure not working.
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.
Confusion about relationships and Measure not working.
1-30 of 103
powered by
Power BI Training
skool.com/power-bi-training-6284
Power BI community for serious learners | Live sessions | DAX | Power Query | Real projects
Build your own community
Bring people together around your passion and get paid.
Powered by