Forum Discussion
Orelim
5 years agoNew Member
Measure to return text value from multiple tables
Hello, I have a data set that looks at call data from 2 different tables. One table reflects calls made to an individual and the other calls made to accounts. Both tables have Call Type which c...
- 5 years ago
Orelim - Perhaps create a table with just the values of your call types. You can do this in an Enter Data query or using DISTINCT. Relate that to both of your tables. Then use that column in this new table in your visual and Total Calls measure.
Greg_Deckler
5 years agoCommunity Champion
Orelim - Perhaps create a table with just the values of your call types. You can do this in an Enter Data query or using DISTINCT. Relate that to both of your tables. Then use that column in this new table in your visual and Total Calls measure.
- Orelim5 years agoNew Member
Greg_Deckler simple and exactly what I was looking for. Thank you