A single value can not be determined problem with filter

[BugmanJ]

Good Day All,

With the following measure:

Measure = 
CALCULATE(
COUNT('Tickets'[Ticket Number]),

FILTER (
ALL ('Tickets'[Operator]),
'Tickets'[Cost] < 25
)
)

It tells me that a single value for the 'Tickets'[Cost] can not be determinted and needs aggregating.

However, I can't aggregate as this forms part of a % calculation. If i remove the ALL filter then it works just fine, but I need the all so that i can have two lines, one where the operator is not filtered and one where the operator gets filtered

Some simple data if really needed:

Ticket Number	Operator	Cost
15	Bob	15
2000	Joe	28
2535	Joe	21
35688	Harry	26

Basically the filter should remove ticket numbers 15 and 2535 whilst ignoring the filter on the page of Operator

Thank you

[BugmanJ · Accepted solution]

So for stopping the filter, this works:

Measure2 = 
CALCULATE(
COUNT('Tickets'[Ticket Number]),
ALL ('Tickets'[Operator]),
ALLEXCEPT(Tickets,Tickets[Cost]),
'Tickets'[Cost] < 25
)

[amitchandak]

@BugmanJ , try one of the two ways

Measure =
CALCULATE(
COUNT('Tickets'[Ticket Number]),

FILTER (
'Tickets',
'Tickets'[Cost] < 25
)
)

or

Measure =
CALCULATE(
COUNT('Tickets'[Ticket Number]),

FILTER (
'Tickets',
'Tickets'[Cost] < 25
),ALL ('Tickets'[Operator])
)

[BugmanJ]

Thanks that removes the error but doesnt stop filtering by the operator.

The entire calculation (as its a %) is

Measure = 
CALCULATE(
COUNT('Tickets'[Ticket Number])
)

/
(
CALCULATE(
COUNT('Tickets'[Ticket Number]),

FILTER (
ALL ('Tickets'[Operator]),
'Tickets'[Cost] < 25
)
)
)*100

This then gives a %