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.
