How to show the total number of records in Clustered Bar Chat?

[Anonymous]

Hi,

I want to show the total number of records in a new bar in Clustered Bar chat? 

Data Format:

Company Name	Company Created
test-prod-credentials	12/10/2020
reliance-cbheritage	6/15/2020
test1	5/8/2020
listglobally	6/15/2020
uatprodtestoctjazlyn	12/10/2020
reliance-cascadesir	6/15/2020
Realogy Brokerage Group	2/27/2020
BrokersTechnology	12/11/2019
sss	6/11/2020
zx	7/31/2020
LuxuryEstate	4/29/2020
Vinodtest2	11/2/2020
Combined Franchise Services	4/29/2020
vinathdev1	11/18/2020
datasync33	7/22/2020
Spacelist	6/2/2020
Cartus	8/26/2019

As of now, I am able to show the company created in 2019 & 2020. But I wanted to show the total number of companies in a new bar.

Thanks in advance. 

[Greg_Deckler]

@Anonymous - Perhaps create a disconnected table with 2019, 2020 and All as rows. Use that in your Axis. You could then create a measure that created a VAR that was MAX of this column. Use that to determine what aggregation to return, either a FILTER'ed set or a count of ALL.

[Anonymous]

@Greg_Deckler Thanks for your guidelines. Like, you said, I created a new table where just to have years  & total and their respective count. 

• Created Year column using this 
  VendorTotal = UNION(DISTINCT(vendor[Company Created].[Year]), ROW("Group Name", "Total")) Year

  and then tried to capture the count of respective year and for the total.

  

  I supposed to pass the year value based on the row, but I am not sure how to pass the year from the "Year" column to get the correct count. Any input would help me.

  Thanks in advance.

[amitchandak · Accepted solution]

@Anonymous , You have created a table only with years like

Year = generateseries(2019,2022,1)

Do not join with other table use as slicer and axis/row in visual

Then create a measure like

measure =
calculate(count(Table[Company Name]), filter(Table, year(Table[Company Created]) >= selectedvalue(Year[Year])))