Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Anonymous Oh, sorry, should just be this:

    test = COUNTROWS(
    SUMMARIZE ( Consult, Consult[date].[year], Consult[date].[month], Consult[id]) )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Anonymous Try:

test = (COUNTROWS(
    SUMMARIZE ( Consult, Consult[date].[year], Consult[date].[month], Consult[id]),
    [Text])

SUMMARIZE will already return each row as a distinct combination of what you are summarizing over.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Its not recognizing the column 'Text' as a column 😕

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Anonymous Oh, sorry, should just be this:

    test = COUNTROWS(
    SUMMARIZE ( Consult, Consult[date].[year], Consult[date].[month], Consult[id]) )