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.

jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

Try this.

Filtered Count = 
SUMX (
    VALUES ( YourTable[Data_Type] ),
    VAR _Type =
        CALCULATE ( SELECTEDVALUE ( YourTable[Data_Type] ) )
    RETURN
        CALCULATE (
            SUM ( YourTable[Data_Count] ),
            YourTable[Data_Queue] = _Type & "_Count"
        )
)