Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Yet Another grouping question

Hi all! I have some data, defined as: Data_Type Data_Queue Data_Count ABC Car 123 ABC ABC_Count 456 DEF Truck 8 DEF DEF 91 DEF DEF_Count 12   I need to show ONLY ...
Need Help
  • sevenhills's avatar
    sevenhills
    3 years ago

    Add the column as

     

    Has Word Count = IF( CONTAINSSTRING( Table_WordFilter[Data_Queue],  Table_WordFilter[Data_Type] & "_Count") , 1, 0)

     

    Or

     

    Has Word Count = IF( Table_WordFilter[Data_Queue] =  Table_WordFilter[Data_Type] & "_Count" , 1, 0)

     

     

    Use this column as filter.

rsbin's avatar
rsbin
Community Champion
3 years ago

Anonymous ,

Create another calculated column:

 

Flag = SWITCH(
           TRUE(),
           AND( CONTAINSSTRING( [Data_Queue], "_Count" ),
                [Data_Type] = LEFT( [Data_Queue], 3 )), 1,
                0 )

Data_TypeData_QueueData_CountFlag

ABC Car 123 0
ABC ABC_Count 456 1
DEF Truck 8 0
DEF DEF 91 0
DEF DEF_Count 12 1

Then filter this new "Flag" column to show only 1's.

Hope this helps.

Regards,