Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

filter calculation

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

     

    I was able to figure out.. 

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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")"