Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Max Count on a certain date base from date Slicer

Hi good day can anyone help me on my measure. i have table with column date, location, Trade and Partner. table is connected to my calendar table. From my calendar table i created filter

What i required is if i filter the date range let say from Feb 01 to July 20 2025 it will show the Max count number of Trade on the paticular date on the date range i filter 

 

Someting like this the result i required

Card:

Table

Thank you

Need Help
  • danextian's avatar
    danextian
    1 year ago

    Try the following, add more columns as needed

    MAXX (
    -- SUMMARIZECOLUMNS creates a table grouped by Partner and Trade
    -- and adds a calculated column "@max" using [POB Max Measure]
    SUMMARIZECOLUMNS(
        'table'[Partner],   -- group by Partner
        'table'[Trade],     -- group by Trade
        "@max", [POB Max Measure]  -- calculate the max value per group
    ),
    [@max]  -- MAXX iterates over the summarized table and returns the maximum of the "@max" column
)

    the max will evaluated for each combination of the columns added.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thankyou, danextian, for your response.

    Hi AllanBerces,

    We appreciate your question on the Microsoft Fabric Community Forum.

    Based on my understanding of the scenario, please find attached a screenshot and a sample PBIX file that may assist in resolving the matter:


    We hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

    Thank you.

5 Replies

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Thankyou, danextian, for your response.

    Hi AllanBerces,

    We appreciate your question on the Microsoft Fabric Community Forum.

    Based on my understanding of the scenario, please find attached a screenshot and a sample PBIX file that may assist in resolving the matter:


    We hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

    Thank you.

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Is POB Max a measure or a column? If a column you can just use MAX ('Table'[POB Max]).

    • AllanBerces's avatar
      AllanBerces
      Icon for Post Prodigy rankPost Prodigy
      1 year ago

      Hi danextian thank you very much for the reply, POB max (trade) is the result of the measure that i;m asking for help on how can i arrive base from my table with column date, location, Trade and Partner

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        1 year ago

        Try the following, add more columns as needed

        MAXX (
    -- SUMMARIZECOLUMNS creates a table grouped by Partner and Trade
    -- and adds a calculated column "@max" using [POB Max Measure]
    SUMMARIZECOLUMNS(
        'table'[Partner],   -- group by Partner
        'table'[Trade],     -- group by Trade
        "@max", [POB Max Measure]  -- calculate the max value per group
    ),
    [@max]  -- MAXX iterates over the summarized table and returns the maximum of the "@max" column
)

        the max will evaluated for each combination of the columns added.