Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summarize two columns

Hi,   I have looked through many forums including this one but can not find a solution.   Issue: I have a table with many rows and I have used bar charts and and a matrix to represent the data. ...
  • Anonymous's avatar
    Anonymous
    7 years ago

    You can try the following DAX

     

    New Table =
SUMMARIZE (
    Activity,
    Activity[Activity],
    "2012", COUNTROWS ( FILTER ( Activity, Activity[Year] = 2012 ) ),
    "2013", COUNTROWS ( FILTER ( Activity, Activity[Year] = 2014 ) )
)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can try the following DAX

 

New Table =
SUMMARIZE (
    Activity,
    Activity[Activity],
    "2012", COUNTROWS ( FILTER ( Activity, Activity[Year] = 2012 ) ),
    "2013", COUNTROWS ( FILTER ( Activity, Activity[Year] = 2014 ) )
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks.

    That's perfect