Forum Discussion

Believer's avatar
Believer
Icon for Advocate IV rankAdvocate IV
4 years ago
Solved

Counting subsets of rows

Considering the following sample data, where the first 4 columns are in a table and the last column (Cust_RecID_Count) is calculated: Customer   RecID   SecID   PosID   Cust_RecID_Co...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    Believer 

     

    You can filter the measure instead of the visual: 

     

    Cust_RecID_Count = IF(ISBLANK([Customer Count]), BLANK(), CALCULATE([Customer Count], ALLEXCEPT('Table', 'Table'[Customer  ], 'Table'[RecID  ])) )

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
4 years ago

Believer 

 

You can filter the measure instead of the visual: 

 

Cust_RecID_Count = IF(ISBLANK([Customer Count]), BLANK(), CALCULATE([Customer Count], ALLEXCEPT('Table', 'Table'[Customer  ], 'Table'[RecID  ])) )

Believer's avatar
Believer
Icon for Advocate IV rankAdvocate IV
4 years ago

AllisonKennedy 

Thank you very much, such a simple fix!  Pretty sure this is also the answer to another question I've had open for a while with no answers... 

I thought there may have been something more extravagant at work here.  I'm still trying to absorb the nuance of CALCULATE filters.  I recently saw that calculate filters are always tables (thanks SQLBI!) and thought somehow this was multiplying the table siginifcantly (given all the extra rows appearing) and that I was using the incorrect approach.