Forum Discussion
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 ...
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.
sevenhills
Super User
Super UserAdd 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.