Rank In PBI

Hi,

TThis si the sample data

For one date there are many published at dates

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

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

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

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

HI , Anonymous 

Thanks for your quick response!

According to your description, you only have one table and you want to show the highest content title. This is my understand and test data for your need:

If this , we canc reate a measure like this:

Measure = 
var _cur_type= MAX('Table'[News Type])
var _t  =CALCULATETABLE( SUMMARIZE('Table','Table'[News Type],'Table'[Content Title],"views" , SUM('Table'[Views])) , ALLEXCEPT('Table','Table'[News Type]))

return
IF(  MAXX(topn(1,_t,[views],DESC) , [Content Title])  = MAX('Table'[Content Title]) , 1, -1)

Then we can put this measrue on the "Filter on this visual":

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,

Thanks for replying...

This is not working
can we do it with rank function if possible?

Hi , Anonymous 

Thanks for your quick response! Soorry for that this dax code can not work in your side . Did you not put [News Type] as dimension in your visual so that the dax code will not work.

If you just put the [Content Title] in the visual , you can use this dax code:

Measure 2 = 
var _cur_type= MAX('Table'[News Type])
var _t  =CALCULATETABLE( SUMMARIZE(ALLSELECTED('Table'),'Table'[News Type],'Table'[Content Title],"views" ,CALCULATE( SUM('Table'[Views]))) )
var _t2  = FILTER(_t, [News Type] = _cur_type)
return
IF(  MAXX(topn(1,_t2,[views],DESC) , [Content Title])  = MAX('Table'[Content Title]) , 1, -1)

Since placing different fields will result in different filtering contexts, if this DAX code still cannot meet your needs, you can provide me with the fields you need to place and your final results in a table form.

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,
I am adding News type as dimension only.

I am adding content title, News type, Views, Published date, created by name

I am filtering it by date

For example If i select between 1st june 2023 to 30th june 2023 it must show only one top view content title for each news

and there is many published dates for one date 
For example for 1st june 2023 there are many published dates

Here view is , content title viewd by user on that date 

Published date is date when the content is published


all this columns i am adding

Please reply
Thanks

Hi , Anonymous 

Thanks for your quick response! According to your description, this is my understand:

If this is the same as yours table structure and the end result is right, you can refer to :
(1)We can create two measures:

MAX views = var _t = SUMMARIZE('Table','Table'[Content Title],"value", SUM('Table'[Views]))
var _t2 = TOPN(1,_t , [value] , DESC )

return
SUMX(_t2 , [value])

MAX COntent Title = var _t = SUMMARIZE('Table','Table'[Content Title],"value", SUM('Table'[Views]))
var _t2 = TOPN(1,_t , [value] , DESC )

return
maxx(_t2,[Content Title])

(2)Then we can put it on the visual and just put the [News type] as the dimension only!

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 Aniya zhang,
Thanks for being patient and replying to my problem

I just need to show this 
only one top content title and it's respective view for each news type

but when i am adding created by name, published date dimension columns into the table
it's showing many values

I'll paste the dax i have used below

Top View = IF ( ISINSCOPE( 'Fact Content'[content_title] ), RANKX ( CALCULATETABLE ( VALUES ( 'Fact Content'[content_title] ), ALLSELECTED( ( 'Fact Content'[content_title] ), 'Fact Content'[Filtered News Type]) ), 'Fact Content'[Month Filter] ) )

Month Filter = CALCULATE(SUM('Fact Content'[nb_content_views]), MONTH('Fact Content'[date]) = MONTH(MAX('Fact Content'[date])) - 1)

the below is the output i am getting

But after adding created by name , published_at columns it's splitting down to many rows like below

Please helpp

It's very important for me

Thanks
sai

Hi , Anonymous 

Thanks for your quick response! According to your screenshot and your dax code . The [Month Filter] measure seems to calculate the views in the previous month . And the [Top View] is used to filter the highest views in your table visual and it work good in your screenshot . And the issue is that when you put the other field like [Created By Name] or the [Published Date] , the table visual will not work.

For this, i think this not the reason for your [Top view] measure. Due to your Views is the previous month so you can not just directly put the other fields to the visual.I also test it in my side , but i still have no sample data as the same as yours so I can't completely guarantee that my situation is exactly the same as yours.

This is my test data and my understand now:

For this i use your two measures you provided and it work good in my side .If you want to add the [Created By Name] or the [Published Date], you may need to create measures to realize it:

Created Name Measure = CALCULATE( MAX('Fact Content'[created by name]) , MONTH('Fact Content'[date]) = MONTH(MAX('Fact Content'[date])) - 1)

Published Date Measure = CALCULATE( MAX('Fact Content'[published_at]) , MONTH('Fact Content'[date]) = MONTH(MAX('Fact Content'[date])) - 1)

Then we can get the right value due to it is from previous month so we can not just directly put it on the visual.

If this method still can not help you solve this case , can you just share me some sample data as the same as yours in a table format , and your end result you need also.Inconsistencies in data structures can complicate things very much, and [Filtered News Type] also appears in your DAX, I'm not sure what the relationship is to [News Type]?Hope this solution can help you!

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,

Thanks for replying,

when I am using the dax you have given the output is like below

It's not showing name and dates for all news types, only for one....please reply

Filtered news type is created column based on one more column

I am taking everything from only one table that is Fact Content

I don't know, why nothing is working here, maybe group by works ....

Please help

Thankss in advance

Hi，  Anonymous 

Thanks for your quick response ! And sory for that this dax code still can not work , it is very strange For this dax "Created Name Measure = CALCULATE( MAX('Fact Content'[created by name]) , MONTH('Fact Content'[date]) = MONTH(MAX('Fact Content'[date])) - 1)" :

This is just calculate the last montn "created by name" as the same logic as your [Month Filter] measure.And for the "Views" in your visual , in my undersand , this is just the  [Month Filter] measure, right?

And only one situation for there is only one poosible is that the [created by name] and [published Date] is contains blank in your table?

Hi ,   Anonymous 

Thanks for the sample data very much!!! But where is the "News Type" in your visual and i can not find it in the sample data....

And dose this [Views] in your table is using your [Month Filter] measure?

And dose your actually need is to see the highest views in the previous month?And i see your sample data there is many blank value  in the [Filtered News Type] and [Content Type]...

And i do not surely understand which you want to group by if used the [Filtered News Type] and [Content Type]?