Forum Discussion
Helper ISame metric from two diff table in QnA
Hi ,
Unfortunately, Q&A doesn't support prioritizing a specific table unless the model is designed with clear naming or relationships.To solve this, consider renaming the measures to make them unique (e.g., “Revenue Own A” and “Revenue Own B”) or create a unified table or calculated table that combines both metrics, so Q&A pulls from a single source. You could also create custom synonyms in the Q&A setup to guide it toward the desired field. This gives you more control and lets users get the right data when they ask questions.
Super UserHi ,
Unfortunately, Q&A doesn't support prioritizing a specific table unless the model is designed with clear naming or relationships.
To solve this, consider renaming the measures to make them unique (e.g., “Revenue Own A” and “Revenue Own B”) or create a unified table or calculated table that combines both metrics, so Q&A pulls from a single source. You could also create custom synonyms in the Q&A setup to guide it toward the desired field. This gives you more control and lets users get the right data when they ask questions.
Community SupportHi poojag820,
I wanted to check if you had the opportunity to review the information provided by rohit1991 pankajnamekar25. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.