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-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 |
5 Replies
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
