Groups based on measure considering date slicer

Hello GaborBenyei,
Thank you for reaching out to the Microsoft Fabric Forum Community.

I’ve reproduced your scenario using sample data matching your raw data structure and achieved the expected output for both date ranges (01/01/2025 - 04/01/2025 and 02/01/2025 - 04/01/2025). I’m attaching a .pbix file for your reference, which includes the solution implemented with your sample data. Below are the steps I followed to create it:

• I loaded your raw data into a table named Transactions in Power BI and checked TransactionDate is formatted as a Date type.
  
  
• Added the following DAX measures to the Transactions table:

ShopCountPerCustomer =

DISTINCTCOUNT(Transactions[ShopId])

CustomersWith1Shop =

CALCULATE(

    DISTINCTCOUNT(Transactions[CustomerId]),

    FILTER(

        ADDCOLUMNS(VALUES(Transactions[CustomerId]), "ShopCount", [ShopCountPerCustomer]),

        [ShopCount] = 1

    )

)

CustomersWith2Shops =

CALCULATE(

    DISTINCTCOUNT(Transactions[CustomerId]),

    FILTER(

        ADDCOLUMNS(VALUES(Transactions[CustomerId]), "ShopCount", [ShopCountPerCustomer]),

        [ShopCount] = 2

    )

)

CustomersWith3OrMoreShops =

CALCULATE(

    DISTINCTCOUNT(Transactions[CustomerId]),

    FILTER(

        ADDCOLUMNS(VALUES(Transactions[CustomerId]), "ShopCount", [ShopCountPerCustomer]),

        [ShopCount] >= 3

    )

)

CustomerCountByShopGroup =

SWITCH(

    SELECTEDVALUE(SummaryCategories[Count of Shops]),

    "1", [CustomersWith1Shop],

    "2", [CustomersWith2Shops],

    "3 or more", [CustomersWith3OrMoreShops],

    BLANK()

)

• Created a disconnected table named SummaryCategories using Enter Data with one column Count of Shops and these values:

• "1"
• "2"
• "3 or more"

• Added a Slicer using Transactions[TransactionDate] set to “Between” mode.
• Added a Table visual with CustomerId and ShopCountPerCustomer to verify per-customer shop counts.
• Added a Table visual with SummaryCategories[Count of Shops] and CustomerCountByShopGroup for the summary output.
  
  

The .pbix file attached demonstrates this working solution with your sample data. You can adjust the slicer to test different date ranges, and the measures will dynamically update to reflect the number of customers grouped by shop counts.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.