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

     

     

jaineshp's avatar
jaineshp
Memorable Member
11 months 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
    Post Prodigy
    11 months 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
      Super User
      11 months 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.