Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have column as below with ID and its element
I would like to calculated column that count the number of element for each ID..as example the count of ROCK as below
How can i do this? Appreciate help from you guys
Solved! Go to Solution.
@qhpowerbi , a new column
if([Element1] ="Rock",1,0) + if([Element2] ="Rock",1,0)+ if([Element3] ="Rock",1,0)
@qhpowerbi , a new column
if([Element1] ="Rock",1,0) + if([Element2] ="Rock",1,0)+ if([Element3] ="Rock",1,0)