Need to unique value in a column and combine with another to produce a count

[Anonymous]

I'm trying to get a simple count for a Card visual.   I have the following table:

Training_Location__c	Training_Class_Date_Code
HQ	1/3/2018-Class 1
HQ	1/3/2018-Class 1
Customer Premises	1/9/2018-Class 1
Customer Premises	1/9/2018-Class 1
HQ	1/12/2018-Class 1
HQ	1/12/2018-Class 1
Customer Premises	3/12/2018-Class 1
Customer Premises	3/12/2018-Class 1
Customer Premises	3/12/2018-Class 1
HQ	5/25/2018-Class 1
HQ	5/25/2018-Class 1
HQ	5/25/2018-Class 2
HQ	5/25/2018-Class 2
Customer Premises	5/31/2018-Class 1
Customer Premises	5/31/2018-Class 1
HQ	8/31/2018-Class 1
HQ	8/31/2018-Class 1
HQ	8/31/2018-Class 2
HQ	8/31/2018-Class 2

Essentially, I'm looking to get a total of the number of classes that were conducted at each location on each date - building a Card visual for each.  There can be training classes on the same date at both location types, and there can be multiple classes at each location on the same date.  The Training_Class_Date_Code provides the unique identifier for the date and the Training_Location_c provides the unique location. 

I've tried to use visual filters in a bunch of different ways, but continually end up with a HQ = 12, Customer Premises = 7.  What I want to to have the Card visual show HQ = 6, Customer Premises = 3.

Effectively this table:

Training_Location__c	Training_Class_Date_Code
HQ	1/3/2018-Class 1
Customer Premises	1/9/2018-Class 1
HQ	1/12/2018-Class 1
Customer Premises	3/12/2018-Class 1
HQ	5/25/2018-Class 1
HQ	5/25/2018-Class 2
Customer Premises	5/31/2018-Class 1
HQ	8/31/2018-Class 1
HQ	8/31/2018-Class 2

[Anonymous · Accepted solution]

I answered my own question.  Created a new merged column

= Table.AddColumn(#"Inserted Merged Column", "Merged_TCDateCode_TLocation", each Text.Combine({[Training_Class_Date_Code], [Training_Location__c]}, "-"), type text)

Then used that result to do the Count (Distinct) from.