Forum Discussion
SUMMARIZE USING DISTINCTCOUNT
Hello, all! I need help with the following issue: I have this table: Year Month ID Text 2021 Jan 123 A 2021 Feb 123 A 2021 Mar 123 A 2021 Mar 123 B 2021 ...
Anonymous Oh, sorry, should just be this:
test = COUNTROWS( SUMMARIZE ( Consult, Consult[date].[year], Consult[date].[month], Consult[id]) )
Its not recognizing the column 'Text' as a column 😕
Greg_Deckler
Community Champion
Community ChampionAnonymous Oh, sorry, should just be this:
test = COUNTROWS(
SUMMARIZE ( Consult, Consult[date].[year], Consult[date].[month], Consult[id]) )