How to structure a count of daily maximum count (Yes, count of a count)

[FOXYBARK]

Hi PBI users. 

I am attaching a sample doc that lays out exactly what I'm looking for. I'm fairly new to PBI. In my example, I would like to have a count of the daily maximum count. How many times was that daily maximum hit?I would like this either as a histogram as shown in my example of even a standalone measure. I'm good with either.  Oh and the catch is the final output needs to be dynamic since we are using slicers. For example, a HR Dept or Building Name slicer. 

This is a snip of sample badge data. 

Badge #	Hr Dept	Badge Date	Building Name
19	ABC	04/15/2022	EDISON
19	ABC	04/16/2022	CARNIGIE
19	ABC	04/17/2022	EDISON
19	ABC	04/18/2022	CARNIGIE
19	ABC	04/19/2022	EDISON
19	ABC	04/20/2022	CARNIGIE
19	ABC	05/31/2022	EDISON
19	ABC	04/22/2022	CARNIGIE
19	ABC	04/23/2022	EDISON
19	ABC	04/24/2022	CARNIGIE
23	ABC	04/15/2022	EDISON
17	ABC	04/18/2022	CARNIGIE
74	ABC	04/15/2022	EDISON
23	ABC	04/18/2022	CARNIGIE
23	ABC	04/19/2022	EDISON
23	ABC	04/20/2022	CARNIGIE
23	ABC	04/21/2022	EDISON
23	ABC	05/15/2022	EDISON

The desired output

Any thoughts on this would be great. I appreciate any assistance. My raw data is a table. 

[FOXYBARK · Accepted solution]

Step 1: In Power Query window, use Group by to group table by table[BadgeDate] with a count. 

Step 2: Create the following measures in the data pane. 

maxcnt = MAX(Data[Count])

cntFinal = COUNT(Data[Final])

Modex = MINX (TOPN (1,ADDCOLUMNS (VALUES ( Table[Badge Date] ),"Frequency", CALCULATE ( COUNT(Table[Badge Date]))),[Frequency],0), Table[Badge Date])

Final = CALCULATE([Modex], Table[Count]=Table[maxcnt])

This set of measures/columns will count how many times the count matches the max count. (Count of a count) CntFinal is the metric you will put on a card for users. 

[v-luwang-msft]

Hi @FOXYBARK ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Anonymous]

Ok no prebs.

Please create a new measure that you can put on a card

maxbadge =

VAR _step1 =

ADDCOLUMNS (

SUMMARIZE ( badge, badge[Badge Date] ),

"Nbr pass", CALCULATE ( COUNT ( badge[Badge Date] ) )

)

VAR result =

MAXX ( _step1, [Nbr pass] )

RETURN

result

[FOXYBARK]

Yes, we are getting closer. In your left most graph, the answer on the card should be '1' and in your rightmost graph, the answer on the card should be '2'. See where I'm going with it? 

[Anonymous]

,

Something like this

I just create this measure ==> 

nb badge = count(badge[Badge Date])

and after building graph and table

[FOXYBARK]

Thank you. I have the measure intact. However, how do I get it to show the histogram such that you have? Or even a standalone measure. Should I do a max(count(badge[Badge Date])? 

[Anonymous]

like this

and for slicers

[FOXYBARK]

Thank you again. I have to apologize as I'm not being clear about my ask. But we're on the right track.  In this example, the count of '3' was reached 2x. I want that number '2' to be the metric I'm displaying. How many times was the daily maximum of '3' hit? Again, my apologies for not being clear. Thank you for your help.