DAX to bring only match results from two tables

Anonymous — Wed, 15 Apr 2020 21:11:24 GMT

Hi,

I hope this question will be very straightforward for someone.Will really appreciate for the response.

For example I have a table called SurveyResults where Q1, Q2 and Q3 has theme saved with score (0-9) in score column

Ref	Date	Q1	Q2	Q3	Score
1	05/04/2020	Happy			3
2	05/04/2020	Sad		Unhappy	5
3	06/04/2020		Happy	Excited	8
4	07/04/2020	Excited			2
5	06/04/2020			Sad	5
6	08/04/2020	Happy			8

Date column contains

DateId	Date
1	01/04/2020
2	02/04/2020
3	03/04/2020
4	04/04/2020
5	05/04/2020
6	06/04/2020
7	07/04/2020
8	08/04/2020
9	09/04/2020
10	10/04/2020

I wanted to show Q1, Q2 and Q3 appended in one column rather than in three columns so I created reference table in Power Query to append three tables and then bring all three tables into one table called SurveyResultDerived as below. (Please suggest if there is a better way to dealing this). In this table Survey Q is all values from Q1, Q2 and Q3 and Question No is additional column to hold which question no it belongs to.

Ref	Date	Survey Q	Score	Question No
1	05/04/2020	Happy	3	Q1
2	05/04/2020	Sad	5	Q1
3	06/04/2020		8	Q1
4	07/04/2020	Excited	2	Q1
5	06/04/2020		5	Q1
6	08/04/2020	Happy	8	Q1
1	05/04/2020		3	Q2
2	05/04/2020	Unhappy	5	Q2
3	06/04/2020	Excited	8	Q2
4	07/04/2020		2	Q2
5	06/04/2020	Sad	5	Q2
6	08/04/2020		8	Q2
1	05/04/2020		3	Q3
2	05/04/2020	Unhappy	5	Q3
3	06/04/2020	Excited	8	Q3
4	07/04/2020		2	Q3
5	06/04/2020	Sad	5	Q3
6	08/04/2020		8	Q3

I was able to show wordcloud using SurveyResultDerived table as it brings all combintion from SurveyResult table and then I got total responses from SurveyResult.

As charts on dashbaord are coming from two tables so selecting one chart does not effect on other chart. How this can be handled? I created a date table in between but if I add a slicer from date table it will bring all dates combinaton from date table whereas i only want matching one.

Kindly suggest how this can be achieved?

Many thanks

Re: DAX to bring only match results from two tables

Greg_Deckler — Wed, 15 Apr 2020 22:30:19 GMT

Not sure I am following everything going on here.

First, for your first table, you could have just unpivoted your Q columns versus what it sounds like you did. Just select the three columns, right-click in Query Editor and choose Unpivot.

Second, it sounds like you are missing a relationship between your two tables.

Re: DAX to bring only match results from two tables

Anonymous — Thu, 16 Apr 2020 09:31:32 GMT

Seems there's too little data to be able to give a definite answer to your question.

Best
D

topic Re: DAX to bring only match results from two tables in DAX Commands and Tips

DAX to bring only match results from two tables

Re: DAX to bring only match results from two tables

Re: DAX to bring only match results from two tables