Forum Discussion
EXCEPT ALLSELECTED
Hi Anonymous ,
Please try the following measure:
INATIVO = VAR selectyear = SELECTEDVALUE ( costumers[year purchase] ) VAR _count = CALCULATE ( COUNT ( costumers[Costumers] ), FILTER ( ALL ( costumers[year purchase] ), costumers[year purchase] > selectyear ) ) RETURN IF ( selectyear <> BLANK (), _count )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionHi Anonymous ,
Create a measure with below code:-
Selected_year =
CALCULATE (
COUNT ( costumers[Costumers] ),
FILTER (
costumers,
costumers[year purchase] = SELECTEDVALUE ( costumers[year] )
)
)less_Selected_year =
CALCULATE (
COUNT ( costumers[Costumers] ),
FILTER (
costumers,
costumers[year purchase] < SELECTEDVALUE ( costumers[year] )
)
)or if you need a complete count of less than and equal to selected year then use this:-
less_equl_Selected_year =
CALCULATE (
COUNT ( costumers[Costumers] ),
FILTER (
costumers,
costumers[year purchase] <= SELECTEDVALUE ( costumers[year] )
)
)
Thanks,
Samarth
Hii, Samarth!!
Thank you for the answearing, but doesn't worked.
Exemple : I filter in slicer the year of 2019, so in the formula the result have to be the amount of costumers 2020,2021 and 2022.
- Samarth_18
Anonymous You mean you need count of customers for next 3 years of selected year?
Yes.