Summarizecolumns using multiple filters

Question

I am new to Power BI.Here is my table.&nbsp;FuncAllCol tableStates&nbsp; &nbsp; &nbsp;Process&nbsp; &nbsp; Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value(TEST)Texas&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A1&nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A2&nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4NY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;I need to get a count of TEST4 for each STate+Company and a percentage complete for each state (Count of Test 2+Test 4 is a full set). I&nbsp; am not able to apply multiple filters on SummarizeColumns. I have below the full counts but am not able to use filter on Calculate say count on&nbsp; Company AA and Value="4" . I appreciate the help on this.&nbsp; &nbsp; &nbsp;&nbsp;Summtest = SUMMARIZECOLUMNS('FuncAllCol'[State],'FuncAllCol'[Company], "Tests Complete Status", CALCULATE(COUNTAX('FuncAllCol','FuncAllCol'[Value]),'FuncAllCol'[Value]="4"), "Tests Reviewed Status", CALCULATE(COUNTAX('FuncAllCol','FuncAllCol'[Value]),'FuncAllCol'[Value]="2" )&nbsp;

anonymous · Accepted Answer

Hi&nbsp;hariik,
&nbsp;
Actually you can direct use matrix to achieve your requirement.
&nbsp;
1. Create matrix visual drag states, company to rows field,2, Drag value to value field, modify summary mode to sum.
&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Summarizecolumns using multiple filters

1 Reply

Related content

SummarizeColumns with Multiple Filters

Simplifying a SUMMARIZECOLUMNS with FILTERS EVALUATE query

Alias on SummarizeColumns

SUMMARIZECOLUMNS' filters overrides ALLEXCEPT?

Multiple Years Filter