Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
qhpowerbi
Helper III
Helper III

DAX = Count value on different column based on other column

‎02-16-2022 12:12 AM

Hi all,

 

I have column as below with ID and its element

qhpowerbi_0-1644998812330.png


I would like to calculated column that count the number of element for each ID..as example the count of ROCK as below

qhpowerbi_1-1644998958699.png

 

How can i do this? Appreciate help from you guys


Labels:
Message 1 of 3
402 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎02-16-2022 12:31 AM

@qhpowerbi , a new column

if([Element1] ="Rock",1,0) + if([Element2] ="Rock",1,0)+ if([Element3] ="Rock",1,0)



View solution in original post

Message 2 of 3
359 Views
0
2 REPLIES 2
qhpowerbi
Helper III
Helper III

‎02-16-2022 12:52 AM

 This is the answer i needed, thank you @amitchandak !

Message 3 of 3
353 Views
0
amitchandak
Super User
Super User

‎02-16-2022 12:31 AM

@qhpowerbi , a new column

if([Element1] ="Rock",1,0) + if([Element2] ="Rock",1,0)+ if([Element3] ="Rock",1,0)



Message 2 of 3
360 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

View All