9d • General discussion
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.
2
6 comments
Confusion about relationships and Measure not working.
powered by
skool.com/power-bi-training-6284
Power BI community for serious learners | Live sessions | DAX | Power Query | Real projects
Suggested communities
Powered by