Display value from value from another table

[Anonymous]

Dear friends

how can i display value from another table to visual like this , i need to display distinct value to visual that row header from other table

Table 1

Date	Type	License
01-01-21	L	AAA
01-01-21	L	BBB
02-01-21	P	CCC
02-01-21	P	CCC

Table Visual *Type column are from table2

Type	Distinct license
L	2
P	1

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Solution1: create a relationship between table1 and table2.

Solution2: create a measure as below.

Measure = CALCULATE(DISTINCTCOUNT('Table'[License]),FILTER('Table','Table'[Type]=SELECTEDVALUE('Table (2)'[Type])))

Best Regards,

Jay

[amitchandak]

@Anonymous , what is the relation between table 1 and table 2. what is the data of table 2

[Anonymous]

@amitchandak for table 2 are transaction like table 1 ,i create some reference for relate by merge date and type for each table

[amitchandak]

@Anonymous , if you have a common type table then the measure 

distinctcount(Table1[License]) should help 

if you do not have one refer https://www.youtube.com/watch?v=Bkf35Roman8

[Anonymous]

@amitchandak i tried but it show all distinct value that not divide by type (ex. boths type L and P display distinct license as 3 )