Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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-...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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