Forum Discussion
DistincCount with Filter
The solution will works. Please try copy it carefully. Then click accept solution. Thanks.
Answer =VAR tempfile = FILTER('yourtable',NOT LEFT('yourtable'[PRODUCT NUMBER],1) IN {"2","3"})RETURNCALCULATE(DISTINCTCOUNT('yourtable'[PRODUCT NUMBER]),tempfile)
Thanks for the clear description of the problem with example data. I wish everyone did that!
Remember we are unpaid volunteers. So please click the thumbs up and the [accept as solution] button to leave kudos.
If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime. This is how I try answer Power BI and DAX questions with clear examples so you learn techniques.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
If you quote @speedramos in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.
Please click the thumbs up and the [accept as solution] button.
The solution will works. Please try copy it carefully. Then click accept solution. Thanks.
Answer =VAR tempfile = FILTER('yourtable',NOT LEFT('yourtable'[PRODUCT NUMBER],1) IN {"2","3"})RETURNCALCULATE(DISTINCTCOUNT('yourtable'[PRODUCT NUMBER]),tempfile)
