Forum Discussion

hariik's avatar
hariik
New Member
8 years ago
Solved

Summarizecolumns using multiple filters

I am new to Power BI.Here is my table.   FuncAllCol table States     Process    Company         Value(TEST) Texas         A1        AA                      2                  A2        AA       ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi hariik,

     

    Actually you can direct use matrix to achieve your requirement.

     

    1. Create matrix visual drag states, company to rows field,
    2, Drag value to value field, modify summary mode to sum.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi hariik,

 

Actually you can direct use matrix to achieve your requirement.

 

1. Create matrix visual drag states, company to rows field,
2, Drag value to value field, modify summary mode to sum.

 

Regards,

Xiaoxin Sheng