Use a Column To Count Unique Entries In A Column Within Another Table

[Anonymous]

All,

I need some help. I am trying to count the number of unique values in a Column from one table and have them entered into a new table that has a list of each unique value in column A of a new table. My solution is coming up incorrect right now.

Here is an example Column from the data set:

Asset - Use

Academic

Other

Academic

Multipurpose

Academic

Now I made a new table with two columns, the first brings out a simple list of these Text lables. I would like to second to count the number of each Asset - Use label

Asset - Use	Sample Size
Academic	3
Other	1
Multipurpose	1

My expression is currently only giving me 1's in each row. Here it is:

Asset_Use_Sample_Size = COUNTROWS(FILTER(ALL('Asset (2)'[Asset - Use]), EXACT(Asset_Use_Summary_Table[Distinct Asset Use Labels], 'Asset (2)'[Asset - Use])))

I cant figure out what I am doing wrong any help would be much appreciated.

Thanks,
Jarrod

[Anonymous]

Thank you @TheoC  that helped big time!

[TheoC · Accepted solution]

Hi @Anonymous 

TotalCount = 

VAR _TotalCount = CALCULATE ( COUNTROWS ( 'tbl_AssetFreq' ) , FILTER ( 'tbl_AssetFreq' , 'tbl_AssetFreq'[AssetFrequency] = 'tbl_AssetCategory'[Asset - Use] ) )

RETURN 

_TotalCount 

No relationship required in the above. The "tbl_AssetFreq" is simply the below:

Hope this helps 🙂