cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
c5vette211 Frequent Visitor
Frequent Visitor

Data Usage Report

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Data Usage Report

Hi @c5vette211,

 

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

1.PNG

 

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.

2.PNG

 

Create measures:

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

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

 

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Data Usage Report

Hi @c5vette211,

 

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

1.PNG

 

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.

2.PNG

 

Create measures:

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

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

 

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.