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 someone be able to help ? I've attached the file below

This is my current measure: 

Busiest Hour Of Month =
MAXX(
TOPN(1,
SUMMARIZE(
'Query1',
'Query1'[Hour],
"Busy Hour", [Total Ins]),
[Busy Hour]),
'Query1'[Hour])



https://drive.google.com/file/d/1PH1BYu4RzBTq811_n_j29FXaP0wcK2vN/view?usp=sharing

Need Help

3 Replies

  • 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 ^ 😞

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi molzmad 

    Has your problem been solved ? If no, please provide your sample and the result you want .

    If it has been solved, provide your method for the problem then consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards

    Community Support Team _ Ailsa Tao