Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Top and Bottom 5

Hi Everyone,    I know its a very simple query but I don;t know why I am not gettting the correct results through filter.   Top5 Conditions   I have student ID along with distance travelled in ...
Top5 and Bottom 5
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

I am able to produce the results by using the filter with Calculate

 

Top 5 = CALCULATE(SUM(table[Distance]),FILTER(Table,table[Star Rating]=5)) and then used filter for more than 100km
 
Thanks for your help.
 
Regards
Uphar