Count how many times the max daily was hit

[FOXYBARK]

I am trying to get the max daily hit count metric. In the example, The max daily count is 14. How many times was this 14 hit? It was 3 times. The number 3 is what I'm trying to dynamically get. Regardless of filters applied, I should always get the max daily hit count. 

Note: some tables have been removed from the dataset for privacy reasons. 

Note: I started something trying to get the answer in the [Data] table. It doesn't work because the max daily hit count is not dynamic. 

Thanks, F

I would attach the wb but not seeing an attach button. 

[v-eqin-msft · Accepted solution]

Hi @FOXYBARK ,

I have built a data sample for test:

Please try the following measures:

Daily Sum = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Date]))

Daily Maximum = MAXX(ALL('Table'),[Daily Sum])

Count of Same Daily Maximum = 
var _t= SUMMARIZE('Table','Table'[Date], "Sum",[Daily Sum])
return COUNTROWS(FILTER(_t,[Sum]=[Daily Maximum]))

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FOXYBARK]

HOw do I attach a file?

[FOXYBARK]

Thank you Eyelyn. 

I think you're on the right track. I'm reattaching your sample workbook where you have your working example. I started to recreate your effort.  The "values" should be more like user ids. I have added a tbl. Can you direct with my example table?

F

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[FOXYBARK]

How do I attach a file?

[Ashish_Mathur]

Hi,

Upload the workbook to OneDrive/Google Drive and share the download link.