Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I am new to Power BI and look to solve the following problem:
I have a table of strings that looks something like this:
Column 1 Column 2
A Yes
A Yes
A No
B Maybe
B Maybe
C Technical
D Technical
D Contract
I want to count (sum) all variables in column 2 for each variable in column 1.
Preffered output looks like:
Column 1 Column 2 Column 3
A Yes 2
A No 1
B Maybe 2
C Technical 1
D Technical 1
D Contract 1
Does anyone know how to solve this? Thank you very much in advance!
With kind regards,
Martijn Kamps
Solved! Go to Solution.
Hi Martijn Kamps,
Actually there are two ways we can go.
Option 1: Use a measure.
Measure = COUNT ( Table1[Column2] )
Option 2: Add column2 twice, then choose count.
Hi,
Could you tell me if this worked? What else can I do for you?
Best Regards!
Dale
Hi Martijn,
My pleasure! I am so glad you have solved the problem.
Best Regards!
Dale
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |