Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |