Forum Discussion

sundayDriver's avatar
sundayDriver
Microsoft Employee
7 years ago
Solved

Measure not respecting a filter

Hello,

I have a date field in the same table as this measure:

EAScal = if(isblank(Divide(Divide(CALCULATE(COUNTA(vwFeedbackData[WouldIsAdminTrueFileTicket]),vwFeedbackData[WouldIsAdminTrueFileTicket] IN {"yes"}),CALCULATE(counta(vwFeedbackData[HelpfulRating]),vwFeedbackData[HelpfulRating] IN {3,2}))*CALCULATE(count(vwFeedbackData[HelpfulRating]),vwFeedbackData[HelpfulRating] IN {1}),CALCULATE(count(vwFeedbackData[HelpfulRating]),vwFeedbackData[HelpfulRating] IN {1,2,3}))),0,Divide((Divide(CALCULATE(COUNTA(vwFeedbackData[WouldIsAdminTrueFileTicket]),vwFeedbackData[WouldAdminFileTicket] IN {"yes"},vwFeedbackData[HelpfulRating] IN {3,2},vwFeedbackData[isadmin]="true"),CALCULATE(COUNT(vwFeedbackData[HelpfulRating]),vwFeedbackData[HelpfulRating] IN {3,2},vwFeedbackData[isadmin]="true"))*CALCULATE(count(vwFeedbackData[HelpfulRating]),vwFeedbackData[HelpfulRating] IN {1},vwFeedbackData[isadmin]="true")),CALCULATE(COUNt(vwFeedbackData[HelpfulRating]),vwFeedbackData[HelpfulRating] IN {1,2,3},vwFeedbackData[IsAdmin]="true")))

Filtering the date doesn't seem to change the measure. Could you help?

 
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi sundayDriver 

    You are creating a column, please select Modeling->New Measure,

    enter the following code

    WouldIsAdminTrueFileTicket =
    IF (
    vwFeedbackData[IsAdmin] = "true",
    IF (
    vwFeedbackData[WouldAdminFileTicket] = "notset",
    "Data not found",
    vwFeedbackData[WouldAdminFileTicket]
    ),
    "N/A"
    )

     

    Best Regards
    Maggie

     

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

3 Replies

    • sundayDriver's avatar
      sundayDriver
      Microsoft Employee
      7 years ago

      Sure Anonymous . Here is a screenshot of some of the data. Here is also the code for the one calculated field used:

      WouldIsAdminTrueFileTicket = if(vwFeedbackData[IsAdmin]="true",if(vwFeedbackData[WouldAdminFileTicket]="notset","Data not found",vwFeedbackData[WouldAdminFileTicket]),"N/A")

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi sundayDriver 

        You are creating a column, please select Modeling->New Measure,

        enter the following code

        WouldIsAdminTrueFileTicket =
        IF (
        vwFeedbackData[IsAdmin] = "true",
        IF (
        vwFeedbackData[WouldAdminFileTicket] = "notset",
        "Data not found",
        vwFeedbackData[WouldAdminFileTicket]
        ),
        "N/A"
        )

         

        Best Regards
        Maggie

         

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