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
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, Anonymous 

Thanks for your quick response!

I test it in my sample pbix file , it seems work .

You can check my pbix file and if we may have some difference in relationships?

Or maybe I've misunderstood your needs too?

 

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,
Thank you so much for replying
It helped

I am trying to show views for that comtent title also, butr what the issue i am facing here is instead of showing the view number for that particular content for a particular news type, it's showing summation of whole news type and showing for a content type

For example:
For Global News Highets viewed content title is GT News1 it must show views number only for that content title
But it's showing summation of whole views for that Globe News News type and same for local news and region news

actually views column is summarized column

Please help me

Thanks in advance