Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Combining Details

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

 

 

Need Help

2 Replies

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.