Hi all,I haveViews in Fact User table and News type in Dim Content table and Content title in Dim Content tableFor each news type I want to see Top 1 Content title which is having Highest viewsLike for Global News I want to see what is the highest views content tileFor Local news I want to see what is the highest views content tileFor regional news I want to see what is the highest views content tilePLease helpThanks in advance

Hi,ContentIddatepublished_atmetadatauser_ididSum of nb_content_viewsSum of nb_content_likesSum of nb_content_commentscontent_titlecontent_type_nameFiltered News Type540204126/28/2023 0:005/12/2023 17:59Video45037090df826ded7681bae5d15e18b56ac242e8100We invited mothers for an unforgettable experienceNewsRegional News593009906/1/2023 0:005/19/2023 21:22Training450370316ef863e1d58ac36e4af26ccab7afe4291002023/06/07: Masterclass: Working Effectively Across CulturesEvents 593009906/1/2023 0:005/19/2023 21:22Training4503703179ba432f759c4b0b7585ba40b395c5891002023/06/07: Masterclass: Working Effectively Across CulturesEvents 593009916/2/2023 0:005/19/2023 21:22Training45037090baec93e847a9ce0b6120c7ec752a69001002023/06/07: Masterclass: Working Effectively Across CulturesEvents 453176816/15/2023 0:005/31/2023 22:00Engagement45037031867d3eca5c6269c5aa8b0c93cb695f90100 News 453176816/15/2023 0:005/31/2023 22:00Engagement45037031ce5d58aeeb337248c65cd492111453b3100 News 498518836/3/2023 0:005/31/2023 22:00Scholarships450370313aa91a5dced42d77103930d97782f972100Deadline: June 15 - 2023 Student AwardsReminders 498518836/3/2023 0:005/31/2023 22:00Scholarships4503703198d6acfcc69c0c706e1eb1971a1beecf100Deadline: June 15 - 2023 Student AwardsReminders 555492806/15/2023 0:006/5/2023 22:00Wellness4503703183d584a5ac9132f424c907fc93d4acad100 News 555492806/15/2023 0:006/5/2023 22:00Wellness450370318f463c95c5c415f43d4e0bcfab9f5ab6100 News 465390036/27/2023 0:006/15/2023 21:47Purpose and Values45037031baf4cd9dfa35724b07046b52c1e8d28b1002023/06/27: Join our Masterclass Events 465390036/27/2023 0:006/15/2023 21:47Purpose and Values45037031d5014526c27083e592727bf8a1cf062f1002023/06/27: Join our MasterclassEvents 573378276/27/2023 0:006/21/2023 22:00 Benefits450370315c6cd758468b2f317e0cf77fff99db1d100 News 573378276/27/2023 0:006/21/2023 22:00 Benefits4503703173b2da007de296674bc8bdc20b5c4d3c100 News 523362396/30/2023 0:006/25/2023 22:00Welcome45037090db8f4d5b62b7635acf6a2906a04af38e100New Iconic EmblemNewsGlobal News525940396/28/2023 0:006/27/2023 14:28Welcome45037090ed801576fd2f050817bc29cf481c5022100Your Way: ‘Easy to Always Be Charged’NewsGlobal News617430636/5/2023 0:007/4/2023 7:00Programs450370319c3c05873d4f44899ea003afbcd835a5100 News TThis si the sample dataFor one date there are many published at dates

Hi , Anonymous According to your description,you want to "see Top 1 Content title which is having Highest views". Here are the steps you can refer to :(1)This is my test data: (2)We can create a measure like this: Measure = MAXX( TOPN( 1, ADDCOLUMNS(VALUES('Dim Content Table'[Content title]),"Views", CALCULATE( SUM('Fact User table'[Views]))) ,[Views]) ,[Content title]) Then we can put the measure on the visual and we can meet your need: If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! ) 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

Hi, Share data in a format that can be pasted in an MS Excel file and show the expected result.

Tables relationships:Fact content to Dim table: Many to oneFact content to Fact user: Many to ManyPlease consider the relationships I created and please help me on this

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

Rank In PBI | Microsoft Fabric Community

24 Replies

v-yueyunzh-msft
Community Support
3 years ago
Hi , Anonymous

According to your description,you want to "see Top 1 Content title which is having Highest views".

Here are the steps you can refer to :
(1)This is my test data:

(2)We can create a measure like this:

Measure = MAXX( TOPN( 1, ADDCOLUMNS(VALUES('Dim Content Table'[Content title]),"Views", CALCULATE( SUM('Fact User table'[Views]))) ,[Views]) ,[Content title])

Then we can put the measure on the visual and we can meet your need:

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

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

20230630 topn1.pbix28 KB
- 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
    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
Ashish_Mathur
Super User
3 years ago
Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result.

Forum Discussion

Rank In PBI

24 Replies

Related content

Duplicate ranking

Ranking KPI card

Rank with conditions

Dynamic Ranking

What are community ranks?