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 fol...
Need Help
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.