Data Usage Report

[c5vette211]

I have an excel file with thousands of questions in it. I am trying to find the trends in these questions and want to build a report that shows common phrases, or frequently used words. i.e. cell = question 'what is your annual revenue?'; 'what is your % of revenue by vertical?' 

With this data can Power BI return a report showing that there are 2 instances of the subject revenue being asked by a customer?

[v-yulgu-msft · Accepted solution]

Hi @c5vette211,

Suppose there is a column listing all questions in your source dataset, as shown below.

I suggest you create an extra table to list some phrases or words that might be frequently used in questions, like below. Later, you should add this column into a slicer for users to choose.

Create measures:

check =
ISERROR (
    FIND (
        SELECTEDVALUE ( Dataset2[Selection] ),
        SELECTEDVALUE ( Dataset1[Question] )
    )
)

count =
CALCULATE (
    COUNT ( Dataset1[Question] ),
    FILTER ( ALLSELECTED ( Dataset1 ), [check] = FALSE () )
)

Best regards,

Yuliana Gu