sentiment count over total surveys

[jcastr02]

I'd like to be able to create a measure showing the number of positive response divided by total number of rows.  In example below should have about 55%  (14/23).   I thought of creating another column and putting if "positive", then 1, if not 0, then taking average, but figured there may be a simpler approach.  Thanks.  

[v-frfei-msft]

Hi @jcastr02 ,

In your scenario, a measure like that can help you.

Measure =
VAR Technician =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            'Table',
            'Table'[what is yuour role] IN { "Technician", "Pharmacist" }
        )
    )
RETURN
    DIVIDE ( Technician, COUNTROWS ( 'Table' ) )

Pbix as attached.

[jcastr02]

Woops, I attached the wrong screen shot.  I apologize @zoloturu @v-frfei-msft 

[jcastr02]

looking for number of positives / total rows  @v-frfei-msft @zoloturu 

[v-frfei-msft · Accepted solution]

Hi @jcastr02 ,

Here we go.

Measure = 
VAR po =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( 'Table', 'Table'[Sentiment] = "Positive" )
    )
VAR countrall =
    CALCULATE ( COUNTROWS ( 'Table' ), ALL ( 'Table' ) )
RETURN
    DIVIDE ( po, countrall )

[jcastr02]

@v-frfei-msft   

How could I get it based on what filters are used, for example, when I filter for Location - "Miami" I see 26% , because its taking into account all surveys, not what is filtered by.   I should see 75% , so 6/8 are positives from Miami.   How can we alter the DAX?  Thanks so much. 

[zoloturu]

@jcastr02 ,

Which method do you use to identify if the value in a column is positive? 

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

[jcastr02]

@zoloturu I don't use anything - This is calculated by microsoft Forms and just gives me responses based on text sentiment, I would just need to know the % of positives over total amount of surveys (rows)