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
Anonymous
Not applicable

Count duplicate values across multiple columns

Hi Guys,

 

I have some survey data across lots of columns. The answers are your typical  satisfied, not satisified, very satisfied. I want to count the number of each answer across the whole table. Then I'll be able to slice that by position, department etc 

 

Is there a DAX formula for this ? 

 

Many thanks 

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @Anonymous,

 

Please show us the table structure as well as sample data, and show us the desired output so that we can test for you.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Johanno
Responsive Resident
Responsive Resident

I think some sample of the data would be great.

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.