Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
So for stopping the filter, this works:
Measure2 =
CALCULATE(
COUNT('Tickets'[Ticket Number]),
ALL ('Tickets'[Operator]),
ALLEXCEPT(Tickets,Tickets[Cost]),
'Tickets'[Cost] < 25
)
So for stopping the filter, this works:
Measure2 =
CALCULATE(
COUNT('Tickets'[Ticket Number]),
ALL ('Tickets'[Operator]),
ALLEXCEPT(Tickets,Tickets[Cost]),
'Tickets'[Cost] < 25
)
@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])
)
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 %
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |