Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year 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 MEASURE - Only the Date with the highest count

Thank you

Need Help
  • danextian's avatar
    danextian
    1 year 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 ) )

     

     

11 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year 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
    Icon for Super User rankSuper User
    1 year 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
      Icon for Post Prodigy rankPost Prodigy
      1 year ago

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

  • jaineshp's avatar
    jaineshp
    Icon for Memorable Member rankMemorable Member
    1 year ago

    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's avatar
      AllanBerces
      Icon for Post Prodigy rankPost Prodigy
      1 year ago

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        1 year ago

        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.

  • Shahid12523's avatar
    Shahid12523
    Icon for Community Champion rankCommunity Champion
    1 year ago

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