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[WouldIsAdminTrueFileTicke...
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.

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.