Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rank In PBI

Hi all, I have Views in Fact User table and News type in Dim Content table and Content title in Dim Content table For each news type I want to see Top 1 Content title which is having Highe...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Tables relationships:

Fact content to Dim table: Many to one
Fact content to Fact user: Many to Many


Please consider the relationships I created and please help me on this

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, Anonymous 

Thanks for your quick response and the relationship image about your model.

For your need , you want to get the "For each news type I want to see Top 1 Content title which is having Highest views".

But for the [news type] in your 'Dim Table' is a measure (if a measure , how do you get this)? Secondly , the [news type] and the [Content_title] is one-to-many?

 

Can you give me some simple test data for these three tables and the end result you want to get in a table format. This will make the case very easy!

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly