Forum Discussion
Rank In PBI
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
Hey Hi,
Thanks alot for replying to all the help
I will place the example data from excel here
Here I just want to see content title which are having highest views
For each news type I want to see content title which are having highest views
| News Type | Content Title | Views |
| Global | team to lead Company through increasingly challenging external environment | 11,900 |
| Region | Competitors are coming | 4,596 |
| Region | Team at exhibition | 3,794 |
| Global | New Iconic | 3538 |
| Loaclity | Solution for disabilities | 1,596 |
For Global, Region and Locality I want to see only top view content title
And I just have only one table that is Fact tavle no other tables are there
can you please help??
Thanks in advance