Combining Details

[Anonymous]

Hello,

seeking your advice on this scenario.

Iiss there any other ways to combine them jus to get accurate results?

for context:

I have a question table, answer table, and vote table following their IDs (24, 26, 27, 28, 29, 30, 31 & 32) that can be found on the "Question" column

 the 24, 26, 27, 28 and 29 - answers should be in between of 1-5 stars, 30 & 32 should be Yes/No, and 31 is for feedback/comment (please see screenshot below)

Answer Table:

    

Vote table:

and the desired result should be like this when using table visual

[Anonymous]

Hi @Anonymous 
You can create a measure directly, you can refer to the following solution.

Based the picture you have offered for the answer table, we assume that you have the related userid.

Thhe following is the sample data 

Question.

Answer

Vote

Useid table

The relationship among the tables.

Then create a measure.

Measure =
VAR a =
    MAXX (
        FILTER (
            ALLSELECTED ( 'Answer' ),
            [id] = MAX ( 'Userid'[id] )
                && [quation_id] = MAX ( 'Question'[id] )
        ),
        [answer]
    )
VAR b =
    MAXX (
        FILTER (
            ALLSELECTED ( 'Vote' ),
            [id] = MAX ( 'Userid'[id] )
                && [question_id] = MAX ( 'Question'[id] )
        ),
        [vote_value]
    )
RETURN
    SWITCH ( TRUE (), a <> BLANK (), a, b <> BLANK (), b )

Output

Best Regards!

Yolo Zhu

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

[dufoq3]

It would be good if you could provide all tables as sample (don't forget to paste them here as table)