Forum Discussion

molzmad's avatar
molzmad
Icon for Helper I rankHelper I
5 years ago

Peak Hour

Hi, Please could someone help me out, on the weekly tab, i want to show the busiest hour within the busiest day of the week/month - but i cant seem to get the measure calculation right, Would someon...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

molzmad , if use only top N for hour, then based on other group by in visual it should give you top hour say by day, week or month

 

CALCULATE(SUM([Total Ins]),TOPN(1,all(Query1[Hour]),calculate(SUM([Total Ins]),DESC),VALUES(Query1[Hour])))

 

Use with hour, day

hour, week

hour , month and check

  • molzmad's avatar
    molzmad
    Icon for Helper I rankHelper I
    5 years ago

    Hi :), 

    as my total Ins, is a measure not a column it wont allow me to do this ^ 😞