Create a new column (or table) from measurements in another table

[musasi77]

Dear experts,

I have a question regarding DAX.

Table1

Case Id	Satisfaction	Recognition	NPS	Month
1001	9	5	9	Jan
1002	7	8	9	Feb
1003	6	4	3	Jan
1004	5	3	3	Feb
1005	4	0	1	Mar

I created measurements with the raw data in table1, for example,

Respondents = DISTINCTCOUNT(Table1[Case Id])

Satisfaction % = DIVIDE( CALCULATE(DISTINCTCOUNT(Table1[Case Id]), Table1[Satisfaction] > 8), [Respondents]

Recognition % = … similar with satisfaction %...

Now I’d like to show the results by Radar chart and I found it requires data as below.

Month	Measurement	Result
Jan	NPS Score	90%
Feb	NPS Score	80%
Mar	CSAT Score	60%

In this case, can I create a new table with measurements in table1?

Really appreciated all your help.

Best regards,

[v-piga-msft]

Hi @musasi77,

It seems that you want to create a calculated table with the measure from table 1? That should be feasible. 

However, I 'm a little confused about your data about CSAT Score and Result column?

If you need further help, please share some data sample which could reproduce your scenario and your desired output, so that we can help further investigate on it?

Best Regards,

Cherry

[musasi77]

Hi @v-piga-msft,

Here's a sample file: Link,

Really thank you in advance.

Best regards,

Hanwool

[v-piga-msft · Accepted solution]

Hi @musasi77,

By my test, it seems that you need an unpivot result which may be not possible for us to achieve that with Dax formula. 

I suggest you could try with another visual to show your data.

Best Regards,

Cherry