How do I calculate the number of occurrences from Column A, based on values of column B, in Power BI

[RaduF]

ColumnA     ColumnB
A        Pass
A        Fail
A        Pass
B        Fail
A        Fail
C          Open
D          Fail
B        Fail
B        Pass
D          Open
E          Pass

Hello! I have a table with the above 2 columns and I need to show each value from ColumnA in a Stacked bar chart, based on ColumnB:

A (first bar) - data stacked 2(Pass)+2(Fail)

B (2nd bar) - data stacked 1(Pass)+2(Fail)

C (3rd bar) - data stacked 1(Open)

And so on.

Thanks!

[BobBI · Accepted solution]

Hi ,

Using your sample data , See the below soluton .

Drag Col A into x Axis

Drag Col B into into Value ( Select Count from context menu)

Drag col B again into Legend

You can also create a masure to calculate count and use measure instread of col B directly.

Hope it helps

Cheers!

Bob