Reply
Highlighted
Regular Visitor
Posts: 44
Registered: ‎10-05-2016
Accepted Solution

DAX Ranking

Dear All,

 

I have an issue, please resolve.

I am associated with a channel company and receive data from rating companies on a daily basis of all the channels on a half-hours’ time slot basis.

I want to work on a measure which provides the selected program rank with all other programs of other channels which telecast on same date and in a same timeslot. This will be an apple to apple comparison.

It should work based on slicer, when I select a particular single program the system should give us that program name, rating, rank and channels with all the programs and all relevant field. The analysis should be based on fresh telecast.

Please Click here   https://drive.google.com/open?id=1E-ModDrvcW6r5_8faX1fZX1nehgxv580 to download rating data in pbix file.

I do the same on a manual basis particularly use pivot table. The demo is given below:

My objective is that when I select “Dur-e-Shehwar”, the system should give me the table as above. Here, the program “Dure-e-Shehwar” was telecasted on 10, 17, 24 and 31 March and the time slot was 20:00-20:50. This is my criteria.


Accepted Solutions
Moderator
Posts: 9,441
Registered: ‎03-06-2016

Re: DAX Ranking

Hi @jamalq123,

 

You can create a measure below: 

 

Rank = RANKX(ALLSELECTED('Rating data'[day]),CALCULATE(SUM('Rating data'[Ratings])))

 

q3.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Attachment

All Replies
Moderator
Posts: 9,441
Registered: ‎03-06-2016

Re: DAX Ranking

Hi @jamalq123,

 

You can create a measure below: 

 

Rank = RANKX(ALLSELECTED('Rating data'[day]),CALCULATE(SUM('Rating data'[Ratings])))

 

q3.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Attachment
Moderator
Posts: 9,441
Registered: ‎03-06-2016

Re: DAX Ranking

Hi @jamalq123,

 

Is the suggestion above helpful for you? 

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.