Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
musasi77
Frequent Visitor

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

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,

1 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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-piga-msft,

 

Here's a sample file: Link,

 

Really thank you in advance.

 

Best regards,

Hanwool

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.