How to Create Graph with Measures as X-axis

[Anonymous]

I am trying to create a bar chart with measures for the x-axis but can't quite get it.

I have a table of contracts, with their final status and dates associated with those statuses. I have created measures to evaluate the status and return a "LIVE" status as per the parameters of a date slider. To do this, I implement a disconnected tables method.

Data table:

Sub Company	Contract Status	Contract Begin Date	Contract Signed Date	Contract Freeze Date	Contract Closed Date
Client-100020	Closed	8/17/2020	8/4/2020		10/6/2020
Client-100071	Frozen	5/24/2021	1/15/2021	1/23/2022
Client-100159	Closed	5/24/2021	4/19/2021		10/2/2021
Client-100170	Closed	2/5/2021	2/4/2021		8/3/2021
Client-100237	Closed	12/31/2020	11/4/2020		3/9/2021

Data table with LIVE status:

Sub Company	Contract Status	Contract Begin Date	Contract End Date	LIVE Status
Client-100020	Closed	8/17/2020	10/6/2020	Closed
Client-100071	Frozen	5/24/2021	1/23/2022	Open
Client-100159	Closed	5/24/2021	10/2/2021	Open
Client-100170	Closed	2/5/2021	8/3/2021	Open
Client-100237	Closed	12/31/2020	3/9/2021	Open

Now, I need to create a bar chart of a count of these clients, based off of the LIVE status.

[Anonymous · Accepted solution]

Oof, I have to improve my Google-Fu. The solution to this very often-asked question can be found in this video by RADACAD - DAX Measure in the Axis of the Power BI Report