Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
11 months ago
Solved

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 MEAS...
Need Help
  • danextian's avatar
    danextian
    11 months ago

    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 ) )

     

     

rohit1991's avatar
rohit1991
Super User
11 months ago

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's avatar
    AllanBerces
    Post Prodigy
    11 months ago

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