Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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
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 , what is the relation between table 1 and table 2. what is the data of table 2
@amitchandak for table 2 are transaction like table 1 ,i create some reference for relate by merge date and type for each table
@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 )
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |