DAX Ranking

[jamalq123]

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.

[v-qiuyu-msft · Accepted solution]

Hi @jamalq123,

You can create a measure below: 

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

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @jamalq123,

Is the suggestion above helpful for you? 

Best Regards,
Qiuyun Yu