Forum Discussion
Q&A to count duplicated values
Hi,
When using Q&A to count how many of an item exists within a column, it responds with a de-duplicated count of the column results.
For example a 'Risk' column has 157 items shown by the card on the top left, however when asking the Q&A (just as an example) it displays 90. The column has some duplicate values but this cannot be changed
When looking at the column data of the query (below) that is demonstrated further:
The column properties for 'Risk' are set to the following (below) but it doesn't matter how I ask the question or what i choose it always displays 90:
This is the same for other columns such as 'Company', but used this as an example
Anonymous Not sure of a solution for this other than adding a unique ID column like an Index:
Tips and tricks for asking questions with Q&A - Power BI | Microsoft Docs
Hi Anonymous ,
I can reproduce your problem, it will sieve out the duplicate values and Q&A visual will only get the aggregated values of non-duplicate values if the text field contains duplicate values. Maybe you can use another field with unique values to get the number of values instead of Risk field. For example, for the data in the table below, the Date field has unique values, and you can use the following statement to get the count of data: how many infosec Date / show me the count of infosec date.
Best Regards
3 Replies
Hi Anonymous and Greg_Deckler
Many thanks for your help. I created a unique ID column seperately (which was a requirement that just churned up for an automation thankfully) i was able to successfully train the Q&A to read the ID column using those field terms.
Greatly appreciated!
- Greg_Deckler
Community Champion
Anonymous Not sure of a solution for this other than adding a unique ID column like an Index:
Tips and tricks for asking questions with Q&A - Power BI | Microsoft Docs
Hi Anonymous ,
I can reproduce your problem, it will sieve out the duplicate values and Q&A visual will only get the aggregated values of non-duplicate values if the text field contains duplicate values. Maybe you can use another field with unique values to get the number of values instead of Risk field. For example, for the data in the table below, the Date field has unique values, and you can use the following statement to get the count of data: how many infosec Date / show me the count of infosec date.
Best Regards