Forum Discussion

Navya's avatar
Navya
Frequent Visitor
4 years ago
Solved

Grouping of Data based on multiple values

Hi,   I am working on text data and need help with grouping rows. Data has 2 columns, below is an example data I am working on :   User Function Name User 1 Function 1 User 1 Function...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Navya 

    You need to create three measures as follows

    Fn 1 = 
CALCULATE(
    DISTINCTCOUNT( Table6[User] ),
    Table6[Function Name] = "Function 1"
)
----------------------------------------------------
Fn 1 & 2 = 
COUNTROWS(
    FILTER(
        VALUES(Table6[User]) ,
        CALCULATE( 
            "Function 1" in VALUES( Table6[Function Name] )  &&  
            "Function 2" in VALUES( Table6[Function Name] )  
        )
    ) 
)

-------------------------------------------------------

COUNTROWS(
    FILTER(
        VALUES(Table6[User]) ,
         CALCULATE( 
            "Function 1" in VALUES( Table6[Function Name] )&&  
            "Function 2" in  VALUES( Table6[Function Name] ) &&
            "Function 3" in  VALUES( Table6[Function Name] )
        )
    ) 
)

     



Fowmy's avatar
Fowmy
Super User
4 years ago

Navya 

You need to create three measures as follows

Fn 1 = 
CALCULATE(
    DISTINCTCOUNT( Table6[User] ),
    Table6[Function Name] = "Function 1"
)
----------------------------------------------------
Fn 1 & 2 = 
COUNTROWS(
    FILTER(
        VALUES(Table6[User]) ,
        CALCULATE( 
            "Function 1" in VALUES( Table6[Function Name] )  &&  
            "Function 2" in VALUES( Table6[Function Name] )  
        )
    ) 
)

-------------------------------------------------------

COUNTROWS(
    FILTER(
        VALUES(Table6[User]) ,
         CALCULATE( 
            "Function 1" in VALUES( Table6[Function Name] )&&  
            "Function 2" in  VALUES( Table6[Function Name] ) &&
            "Function 3" in  VALUES( Table6[Function Name] )
        )
    ) 
)

 



Navya's avatar
Navya
Frequent Visitor
4 years ago

Thank You !! This worked