Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
11 months 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
    11 months 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
    11 months 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
    11 months 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
    11 months 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
      11 months 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
        11 months 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.