topic Re: Custom Column Min and Max Count Difference of a Group in DAX Commands and Tips

Custom Column Min and Max Count Difference of a Group

Anonymous — Thu, 21 Jul 2022 22:44:14 GMT

See below. Need a custom column that returns the difference between the min and max count of the 'count_column' grouped by the 'group_column'. And then return a boolean. Something like:

CALCULATE( MIN( COUNT(table[count_column])) - MAX( COUNT(table[count_column])), ALLEXCEPT(table,table[group_column]) ) = 0

group_column	count_column
A	text
A	text
B	text
B	text
C	text

Re: Custom Column Min and Max Count Difference of a Group

vapid128 — Thu, 21 Jul 2022 22:53:32 GMT

where is your customer ID?

Re: Custom Column Min and Max Count Difference of a Group

Anonymous — Fri, 22 Jul 2022 16:20:54 GMT

Not sure what you're referring to. For additional clarity. I'm using matrix visual that needs to be filtered if a value (column_count) changes over time. Hence the min minus max. So there is no cutomer ID. Each row has a date associated with it. The count of items for that calandar week needs to be compared across time and then a boolean value is returned if that value has changed.