Max Count

[AllanBerces]

Hi good day can someone help me on my maeasure, on my table with column Date, BP's, laborType. i want to get the highest count of Labortype on what date.

From my table 

DESIRED RESULT OF MEASURE - Only the Date with the highest count

Thank you

[danextian · Accepted solution]

Hi @AllanBerces .

Create a virtual summarized table of each date and the value. Pick the one with the highest value using TopN and use that top date as a filter

Max Value Date =
VAR TopDate =
    CALCULATE (
        MAXX (
            TOPN (
                1,
                ADDCOLUMNS (
                    SUMMARIZE ( ALLSELECTED ( Dates ), Dates[Date] ),
                    "@value", [Total Transactions] -- or your count measure
                ),
                [@value], DESC
            ),
            [Date]
        ),
        ALLSELECTED ()
    )
RETURN
    CALCULATE ( [Total Transactions], KEEPFILTERS ( Dates[Date] = TopDate ) )

[AllanBerces]

Hi @danextian @Shahid12523 @rohit1991 thank you very much for the reply working as i need

[AllanBerces]

Hi @jaineshp thank you very much for the reply but it show error

thank you

[Natalie_iTalent]

Hello @AllanBerces,

The comment you were responding to has been removed. 

Best,

Natalie H.

Community Manager 

[rohit1991]

Hi @AllanBerces 

You can achieve this directly using a Top N filter on the Matrix visual.

Steps:

Create a simple measure for your counts:

Total Count =
SUM ( Fact[Qty] )

Build your Matrix:

• Rows >> DPR_DATE >> LaborType
• Values >> [Total Count]

In the Filters on this visual pane:

• Drag DPR_DATE into the filters.
• Change the filter type to Top N.
• Set Show items = Top 1.
• By value >> drop [Total Count].
• Click Apply filter.

Result:

The Matrix now shows only the date that has the highest total count (in your case, 2 June 2025 = 234) along with the LaborType breakdown underneath.

[AllanBerces]

Hi @rohit1991 thank you very much for the reply but i cant used that way, i will add this measure to other table

[Shahid12523]

MaxLaborTypeDate =
CALCULATE (
MAX ( 'YourTable'[Date] ),
TOPN (
1,
SUMMARIZE ( 'YourTable', 'YourTable'[Date], "Count", COUNTROWS ( 'YourTable' ) ),
[Count], DESC
)
)

[AllanBerces]

Hi @Shahid12523 thank you very much for the reply but data show on the measure

[jaineshp]

Hey @AllanBerces,

You can try using this measure:

Max Count =
VAR MaxCountInTable =
CALCULATE(
MAX([Count]),
ALLSELECTED()
)
RETURN
IF(
[Count] = MaxCountInTable,
[Count],
BLANK()
)

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer

[AllanBerces]

Hi @jaineshp thank you very much for the reply but i dont know where can i get the count you used on the measure. I try to used the measure i created but show error

My Measure on count

Trade Count = COUNT('Table01'[Labor Type])

Thank you

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.