Forum Discussion

Spencer's avatar
Spencer
Helper II
10 years ago
Solved

Summarize Columns - Keeping blank rows

Hi, and apologies in advance if I'm missing something really simple. (Just haven't been able to find a solution elsewhere).   I'm creating a new table by using the SUMMARIZECOLUMNS function and am ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    hi Spencer

     

    1. Create a Table with Months and related to Employee Master with Month Joined Column.

     

    2. Create a new table with this Dax:

    Monthly = SUMMARIZECOLUMNS(Months[Month];"Starters";If(COUNTROWS(RELATEDTABLE(Employee Master))>0;COUNTROWS(RELATEDTABLE(Employee Master));0))
Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

hi Spencer

 

1. Create a Table with Months and related to Employee Master with Month Joined Column.

 

2. Create a new table with this Dax:

Monthly = SUMMARIZECOLUMNS(Months[Month];"Starters";If(COUNTROWS(RELATEDTABLE(Employee Master))>0;COUNTROWS(RELATEDTABLE(Employee Master));0))