Filter this Summary Table

[PaulPalkowski]

I want the table to be created with Change Counts DAgreater than 4 , can that be done from here?

here is my DAX

NotAuditedAssignees =

CALCULATETABLE (

SUMMARIZE (

AllChanges,

'AllChanges'[AssignRenamer],

'AllChanges'[TypeRisk],

'AllChanges'[MAX-AssignAudited],

"Change Count", SUMX ( AllChanges, AllChanges[CounterColumn])+0

), 'AllChanges'[TypeRisk] in {"Standard ", "Normal Low"}, AllChanges[MAX-AssignAudited]=0)

"}, AllChanges[MAX-AssignAudited]=0)

[v-yangliu-msft]

Hi  @PaulPalkowski  ,

According to your description, I create some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
var _filter=
FILTER('Table',[TypeRisk] in {"Standard","Normal Low"}&&[MAX-AssignAudited]=0)
var _1=
SUMMARIZE(_filter,[AssignRenamer],[TypeRisk],[MAX-AssignAudited],
"Change Count",COUNT('Table'[CounterColumn]))
return
FILTER(_1,[Change Count]>=4)

2. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

What is the end goal? You can either filter in the SUMX or the SUMMARIZE:

NotAuditedAssignees =

CALCULATETABLE (

SUMMARIZE (

FILTER(AllChanges, AllChanges[Change Counts DA] > 4 ) ,

'AllChanges'[AssignRenamer],

'AllChanges'[TypeRisk],

'AllChanges'[MAX-AssignAudited],

"Change Count", SUMX ( AllChanges, AllChanges[CounterColumn])+0

), 'AllChanges'[TypeRisk] in {"Standard ", "Normal Low"}, AllChanges[MAX-AssignAudited]=0)

"}, AllChanges[MAX-AssignAudited]=0)

[PaulPalkowski]

There isn't any column that counts changes in the source 'All Changes',  

I want the table to only show me anyone with more than 4 changes, right now I am getting everyone

[AllisonKennedy · Accepted solution]

Please share the full sample table - your screenshot is still missing CounterColumn for example - and all DAX for any calculated columns. 

You need to count the changes first - is there any date range involved here?