DAX Formula

[hosea_chumba]

DAX issue

Wednesday

I have a table "Sales"with the columns for product, customer number and group ID. I would like to identify groups that have more than 5 members for product "M", why is the below formula not working, kindly suggest a better approach;

GroupsWithMoreThanFiveMembersAndProduct is M =

CALCULATETABLE(

   SUMMARIZE(

       FILTER(

           'Sales',

           'Sales'[Product] = "M"

       ),

       'Sales'[Group ID],

       "Count", COUNT('Sales'[Customer Number])),

   [Count] > 5

)

[eliasayyy · Accepted solution]

can you please try 

GroupsWithMoreThanFiveMembersAndProduct is M =
FILTER(
    CALCULATETABLE(
        SUMMARIZE(
            'Sales',
            'Sales'[Group ID],
            "Count", COUNT('Sales'[Customer Number])
        ),
        'Sales'[Product] = "M"
    ),
    [Count] > 5
)

[FreemanZ · Accepted solution]

hi @hosea_chumba ,

try like:

GroupsWithMoreThanFiveMembersAndProduct is M =
FILTER(
    ADDCOLUMNS(
       SUMMARIZE(
            'Sales',
            'Sales'[Product], 
            'Sales'[Group ID]
        ),
        "Count", 
        CALCULATE(COUNT('Sales'[Customer Number]))
    ),
    [Count]>5&&'Sales'[Product] = "M"
)

[eliasayyy · Accepted solution]

can you please try 

GroupsWithMoreThanFiveMembersAndProduct is M =
FILTER(
    CALCULATETABLE(
        SUMMARIZE(
            'Sales',
            'Sales'[Group ID],
            "Count", COUNT('Sales'[Customer Number])
        ),
        'Sales'[Product] = "M"
    ),
    [Count] > 5
)