Forum Discussion
Display value from value from another table
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-...
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
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
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 )