Create a Calculated Column from Different Tables

[Rahul66303]

Hi Members,

I am new to power BI and need an help to build a visualization:

Below are my two tables :

TestCases
ID	Title	Identifier
1	Title1	x
2	Title2	y
3	Title3	x
4	Title4	y
5	Title5	x

CoveredTestCases
ID	Title	Identifier
1	Title1	x
2	Title2	x
3	Title3	y

I want to build clustered bar chart based on identifier (x,y) as total (count of x,y in TestCases table) vs covered (count of x,y in CoveredTestCases table).

 something like this as per below screen shot :

Looking forward your quick help here.

Thanks,

Rahul

[v-yulgu-msft · Accepted solution]

Hi @Rahul66303,

Create an extra calculated table:

New Table1 =
UNION (
    SELECTCOLUMNS (
        TestCases,
        "TestCases", "TestCases",
        "Identifier", TestCases[Identifier]
    ),
    SELECTCOLUMNS (
        CoveredTestCases,
        "CoveredTestCases", "CoveredTestCases",
        "Identifier", CoveredTestCases[Identifier]
    )
)

Drag corresponding fields from above table into bar chart visual.

Best regards,

Yuliana Gu