Q&A to count duplicated values

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