topic custom column - min of count - group by week number in DAX Commands and Tips

custom column - min of count - group by week number

Anonymous — Fri, 22 Jul 2022 17:51:26 GMT

See below. Need custom column that shows the minimum count of the textColumn grouped by week.

weekNumber	textColumn	customColumn
1	A	1
1	B	1
2	A	1
2	B	2
2	B	2

Re: custom column - min of count - group by week number

Greg_Deckler — Fri, 22 Jul 2022 18:46:53 GMT

Anonymous Thinking something like:

Measure = MINX(SUMMARIZE('Table',[weekNumber],"__Count",COUNTROWS('Table'))

Re: custom column - min of count - group by week number

Anonymous — Fri, 22 Jul 2022 19:09:40 GMT

I need a column, not a measure Greg_Deckler

Re: custom column - min of count - group by week number

Greg_Deckler — Fri, 22 Jul 2022 19:14:05 GMT

Anonymous

Column = MINX(SUMMARIZE(ALL('Table'),[weekNumber],"__Count",COUNTROWS('Table'))

Re: custom column - min of count - group by week number

Anonymous — Mon, 25 Jul 2022 08:11:21 GMT

Hi Anonymous ,

Please try below dax formula to add a new column:

customColumn = VAR cur_weekNumber = 'Table'[weekNumber] VAR cur_textColumn = 'Table'[textColumn] VAR temp_table = FILTER ( 'Table', 'Table'[weekNumber] = cur_weekNumber && 'Table'[textColumn] = cur_textColumn ) RETURN COUNTROWS ( temp_table )

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.