topic Re: DAX Formula in DAX Commands and Tips

DAX Formula

hosea_chumba — Fri, 10 Nov 2023 14:29:29 GMT

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

)

Re: DAX Formula

eliasayyy — Fri, 10 Nov 2023 14:40:45 GMT

can you please try

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

Re: DAX Formula

FreemanZ — Fri, 10 Nov 2023 14:42:41 GMT

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