Forum Discussion

mizaskun's avatar
mizaskun
Icon for Helper II rankHelper II
5 years ago
Solved

Summarize by three columns

Good morning,   I have the following table:   USER  |  YEAR  |  REGION  |  RISK  |  VALUE A  |  2019  |  EUROPE  |  A  |  2 B  |  2019  |  EUROPE  |  A  |  3 C  |  2019  |  EUROPE  |  A  |  4 ...
DAX
  • AlB's avatar
    AlB
    5 years ago

    mizaskun 

    Probably best to do this in PQ. If you want it in DAX:

    NewTable =
ADDCOLUMNS (
    SUMMARIZE ( Table1, Table1[YEAR], Table1[REGION], Table1[RISK] ),
    "@Average", CALCULATE ( AVERAGE ( Table1[Value] ) )
)

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.