Forum Discussion
Summarized Table - Total By Column
Hi I need help to calculate (Total By Company) in my summary table , below is the code for the summarized table : Summary Table =
SUMMARIZE('Table1',
'Table1'[Company],
'Table1'[Type],
...
You want to do something like this:
Summary Table = ADDCOLUMNS ( SUMMARIZE( 'Table1', 'Table1'[Company], 'Table1'[Type] ), "Emp", CALCULATE ( DISTINCTCOUNT('Table1'[UserID]) ), "Total Company Emp ", CALCULATE ( DISTINCTCOUNT('Table1'[UserID]), ALLEXCEPT ( Table1, Table1[Company] ) ) )You'll notice I've used SUMMARIZE in combination with ADDCOLUMNS rather than letting SUMMARIZE do the aggregation. Have a read of All The Secrets of Summarize
This not what i am looking for , the column (Type) is missing .. I want the (Total By Company) grouped based on the company with (type) coulmn present in the table .
I think my suggestion does what you need.