Forum Discussion
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 someone please help me
TIA
Tan
3 Replies
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
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")"
