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

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

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

Hi , Anonymous 

Thanks for your quick response !

According to your description, you want to show views.

I create two measures you can check if it can meet your need:

Value Per News Type = CALCULATE( SUM('Fact User'[Views]) , ALLEXCEPT('Dim Content','Dim Content'[News Type]))
Max Value = CALCULATE( SUM('Fact User'[Views]) , TREATAS({[Max Value of Content title]} , 'Dim Content'[Content tiltle]) , ALLEXCEPT('Dim Content','Dim Content'[News Type])   )

We can test it in the visual , the reuslt is as follows:

 

If this still does not meet your needs, you can provide me with the final results you want in a form based on my test data.

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