custom column - min of count - group by week number

[Anonymous]

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

[Greg_Deckler · Accepted solution]

@Anonymous 

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

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

@Anonymous Thinking something like:

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

[Anonymous]

I need a column, not a measure @Greg_Deckler 

[Greg_Deckler · Accepted solution]

@Anonymous 

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