Forum Discussion

MSW's avatar
MSW
Helper I
3 years ago
Solved

Cross Section between Two Groups

Hello I am trying to assess some survey data and struggling to figure out how to find cross sections between varying groups.    I have categories for each as defined by the questions and aggregates...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, MSW 

     

    You can try the following methods.
    Sample data:

    Measure =
CALCULATE (
    COUNT ( 'Table'[Response ID] ),
    ALLEXCEPT ( 'Table', 'Table'[score] )
)

    Is this the result you expect? If not, provide sample data and the output you expect.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi MSW 

try to write a measure like this:

AdvancedNeutralCount =
VAR _list1 = 
CALCULATETABLE(
     VALUES(TableName[ResponseID]),
     TableName[Score]="Advanced")
)
VAR _list2 = 
CALCULATETABLE(
     VALUES(TableName[ResponseID]),
     TableName[Score]="Neutral")
)
RETURN
COUNTROWS(INTERSECT(_list1, _list2))