Forum Discussion

lherbert501's avatar
lherbert501
Icon for Post Prodigy rankPost Prodigy
3 years ago

Rank by second field (latest date)

Hi there,   I want to rank the top 5 locations by the amount of calls that come in for each location, but then when the calls are joint, then possibly refer to the most recent on the joint occurenc...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

lherbert501 ,  refer this example of TOPN

 

2 column top N = CALCULATE( SUM ( 'Fact'[Value] ), TOPN(10, SUMMARIZE(ALLSELECTED('Fact'), 'Fact'[Location], 'Fact'[Date]), CALCULATE ( SUM ( 'Fact'[Value] ) ),DESC),VALUES('Fact'[Location]), VALUES('Fact'[Date]) )

 

  • lherbert501's avatar
    lherbert501
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    Hi amitchandak 

     

    Thanks for your reply.

     

    I've implemented the location and date but it's still displaying as joint 1's like in the image.