Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column 'RAW SLA%' in table 'Query1' cannot be found or may not be used in this expression.

hii 

 

i was getting an error i am trying to count the sla% the same formula i used for call closed it is working perfectly but my sla % is not

 

Count of Call Closed 1 =
CALCULATE (
COUNT(Query1[Call Closed]),
FILTER (
Query1,
Query1[Call Closed].[MonthNo] <= [Selected Slicer]
&& Query1[Call Closed].[MonthNo] >= [Selected Slicer] - 2
&& Query1[Call Closed].[Year] = YEAR ( TODAY () )
)
)

Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    6 years ago

    @greeshma

    I'm not sure what the RAW SLA% measure returns, to the next measure if you need to count the rows.

    ROW SLA% 1 =
CALCULATE(
COUNTROWS( Query1 ),
    FILTER (
        Query1,
        Query1[Call Closed]. [MonthNo] <= [Selected Slicer]
        && Query1[Call Closed]. [MonthNo] >= [Selected Slicer] - 2
        && Query1[Call Closed]. [Year] = YEAR ( TODAY () )
    )
)


    You may need to average % of results

    ROW SLA% 1 =

AVERAGEX(
    FILTER (
        Query1,
        Query1[Call Closed]. [MonthNo] <= [Selected Slicer]
        && Query1[Call Closed]. [MonthNo] >= [Selected Slicer] - 2
        && Query1[Call Closed]. [Year] = YEAR ( TODAY () )
    ),
    [RAW SLA%]
)



    ________________________

    If my answer was helpful, consider Accepting it as the solution to help other members find it

    Click the Thumbs-Up icon if you like this answer 🙂

    Youtube Linkedin

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , is [RAW SLA%] a measure if so, use it without count

     

    or use countx(Query1,[RAW SLA%]) .

     

    If it is column, try to get exact name in the formula

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hiii amit 

      i tried with countx it is still showing an error

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    @greeshma

    I'm not sure what the RAW SLA% measure returns, to the next measure if you need to count the rows.

    ROW SLA% 1 =
CALCULATE(
COUNTROWS( Query1 ),
    FILTER (
        Query1,
        Query1[Call Closed]. [MonthNo] <= [Selected Slicer]
        && Query1[Call Closed]. [MonthNo] >= [Selected Slicer] - 2
        && Query1[Call Closed]. [Year] = YEAR ( TODAY () )
    )
)


    You may need to average % of results

    ROW SLA% 1 =

AVERAGEX(
    FILTER (
        Query1,
        Query1[Call Closed]. [MonthNo] <= [Selected Slicer]
        && Query1[Call Closed]. [MonthNo] >= [Selected Slicer] - 2
        && Query1[Call Closed]. [Year] = YEAR ( TODAY () )
    ),
    [RAW SLA%]
)



    ________________________

    If my answer was helpful, consider Accepting it as the solution to help other members find it

    Click the Thumbs-Up icon if you like this answer 🙂

    Youtube Linkedin