Forum Discussion
EXCEPT ALLSELECTED
HI!!!! I have a table with costumers and year, and i have to count the numbers of costumers accordingly the year selected in the slicer, and count the numbers of costumers that less than the year...
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.
Anonymous You mean you need count of customers for next 3 years of selected year?
Yes.
Anonymous Please try:-
Selected_year = CALCULATE ( COUNT ( costumers[Costumers] ), FILTER ( costumers, costumers[year purchase] > SELECTEDVALUE ( costumers[year] ) && costumers[year purchase] <= SELECTEDVALUE ( costumers[year] ) + 3 ) )Srry samarth, bus doesn't worked too.
The result of the count it's like considering only 2020 and 2022.
Anonymous is it possible for you to share your PBIX file after removing sensitive data? and also the expected output?