Forum Discussion

PaulPalkowski's avatar
PaulPalkowski
Helper II
5 years ago
Solved

Filter this Summary Table

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)
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    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?

4 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago

    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's avatar
      PaulPalkowski
      Helper II
      5 years ago

      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's avatar
        AllisonKennedy
        Community Champion
        5 years ago

        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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.