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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
P_P2595
Helper I
Helper I

create a new column for distinct values based on another column in matrix visual.

Hello experts,

 

I have been struggling to find a solution for this. I want to count a distinct value based on specialty.

I’ve got a table with some calculations as below.

 

Input:

SERVICE TYPE

Class Observations

Educators supported

CASE TYPE

Project

Project1

APPOINTMENT TYPE

Observation at school

Educator Group Session

Staff Consult

APPOINTMENT TYPE CODE

OAS

EGRSE

SC

SPECIALITY

Occupational Therapist

Psychologist

Social Worker

Occupational Therapist

Occupational Therapist

Psychologist

Speech Therapist

SCHOOL (Care team)

MRN

Count of MRN

Count of MRN

Count of MRN

Count of MRN

Count of MRN

Count of MRN

Count of MRN

Coutts Crossing Public School

12345

1

1

1

1

1

1

1

Total

1

1

1

1

1

1

1

 

Expected output:

 

SERVICE TYPE

Observations

 

Educators

 

      

CASE TYPE

Project

 

Project1

 

      

APPOINTMENT TYPE CODE

OAS

 

EGRSE

SC

 

     

SPECIALITY

Occupational Therapist

Psychologist

Social Worker

 

Occupational Therapist

Occupational Therapist

Psychologist

Speech Therapist

 

 

SCHOOL (Care team)

MRN

Count of MRN

Count of MRN

Count of MRN

Total

Count of MRN

Count of MRN

Count of MRN

Count of MRN

Total

Coutts Crossing Public School

12345

1

1

1

1

1

1

1

1

1

 

In short, I want to create a total column that can give me a distinct value for each service type (Observations, Educators etc…)

Any help would be greatly appreciated. Thanks in advance.

1 REPLY 1
parry2k
Super User
Super User

@P_P2595 it is important to know what raw data looks like, share the sample of raw data.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors