Forum Discussion

gsxr's avatar
gsxr
Frequent Visitor
4 years ago
Solved

Cross filtering within the same table using another column

Hi, I would like to know if it's possible to cross filter within the same table but using another column. More specifically, my table looks like this: Customer Activity Type Activity Result ...
Need Help
  • danextian's avatar
    danextian
    4 years ago

    Hi gsxr ,

     

    You can create a measure that aggregates based on a unique item in a field/column using ALLEXCEPT but other than that I can't think of a way for Power BI to do it automatically.


    Here's a sample measure

    Row count by Customer = 
CALCULATE ( COUNTROWS ( Data ), ALLEXCEPT ( Data, Data[Customer] ) )


    As shown the screenshot below, C3 has for rows. The other visuals show this count even if only the row containing C3/T1/R6 is clicked.

     

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi gsxr ,

 

You can create a measure that aggregates based on a unique item in a field/column using ALLEXCEPT but other than that I can't think of a way for Power BI to do it automatically.


Here's a sample measure

Row count by Customer = 
CALCULATE ( COUNTROWS ( Data ), ALLEXCEPT ( Data, Data[Customer] ) )


As shown the screenshot below, C3 has for rows. The other visuals show this count even if only the row containing C3/T1/R6 is clicked.