Forum Discussion
Max Count
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
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 ) )
11 Replies
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 ) )Hi danextian Shahid12523 rohit1991 thank you very much for the reply working as i need
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.
Hi rohit1991 thank you very much for the reply but i cant used that way, i will add this measure to other table
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 DeveloperHi 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 youHi,
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.
MaxLaborTypeDate =
CALCULATE (
MAX ( 'YourTable'[Date] ),
TOPN (
1,
SUMMARIZE ( 'YourTable', 'YourTable'[Date], "Count", COUNTROWS ( 'YourTable' ) ),
[Count], DESC
)
)Hi Shahid12523 thank you very much for the reply but data show on the measure
Hello AllanBerces,
The comment you were responding to has been removed.
Best,
Natalie H.
Community Manager
