Peak Hour

[molzmad]

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

[Anonymous]

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

[amitchandak]

@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]

Hi :), 

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