Forum Discussion

MSW's avatar
MSW
Icon for Helper I rankHelper 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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
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.