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

[Anonymous]

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

)

)

[Fowmy · Accepted solution]

@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

[amitchandak]

@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]

hiii amit 

i tried with countx it is still showing an error