Forum Discussion

Jbmolina93's avatar
Jbmolina93
Frequent Visitor
8 years ago
Solved

Create view from table

I have a dataset with columns person, age, department, and date. I'm trying to get the sum of people under the age of 18 grouped by the department from that month.  Attached is an example data set. ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Jbmolina93

     

    Hi, Try with this

     

    MyTable2 =
SUMMARIZE (
    FILTER ( Table1; Table1[Age] < 18 );
    Table1[Name];
    Table1[Date].[Month];
    "Department A Total"; CALCULATE ( COUNT ( Table1[Name] ); Table1[Department] = "A" );
    "Department B Total"; CALCULATE ( COUNT ( Table1[Name] ); Table1[Department] = "B" )
)

    Regards

     

    Victor

    Lima - Peru

Jbmolina93's avatar
Jbmolina93
Frequent Visitor
8 years ago

I know you can use a matrix to visualize this but what I'm trying to do is get this data on a new table. Dax is not my strong suit yet. 

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

Jbmolina93

 

Hi, Try with this

 

MyTable2 =
SUMMARIZE (
    FILTER ( Table1; Table1[Age] < 18 );
    Table1[Name];
    Table1[Date].[Month];
    "Department A Total"; CALCULATE ( COUNT ( Table1[Name] ); Table1[Department] = "A" );
    "Department B Total"; CALCULATE ( COUNT ( Table1[Name] ); Table1[Department] = "B" )
)

Regards

 

Victor

Lima - Peru