filter calculation

[Anonymous]

I am trying to calculate a percentage of Negtive Responses ie .10/2363 . I have tried writing queries but cant get to it.. The negative responses is a based on filter and so is all repsonses.

Can someone please help me 

TIA

Tan

[v-yuta-msft]

Hi Tan,

Try DAX formula like below and try again:

Percentage =
CALCULATE ( SUM ( table[Negetive Responses] ), ALLSELECTED ( table[date] ) )
    / CALCULATE ( SUM ( table[All Responses] ), ALLSELECTED ( table[date] ) )

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

I was able to figure out.. 

[Anonymous]

Hello Jimmy  

Thanks issue is the sum function wont work because of string

as the repsonses are based on a condition where it checks for a name and if a name exists its negative and if no name  than its positive.

2 level is I have to select some names which are not to be included in negative total.  I have attached another screen shot to show how I get to the negatives. 

Queries used   "Check for Blank = ISBLANK(SurveyDashboard[ClientName])"

and to display in legend "Customer Feedback = IF(SurveyDashboard[Check for Blank],"All Responses","Negatives")"