stupid question.. but I really cannot fix it..
I am trying to distinct count the values in column A excluding the values in column B
The result should be 3... but if I do.. =CALCULATE(DISTINCTCOUNT(Table1[A]);ALLEXCEPT(Table1;Table1[B])) doesn't work.. how should I fix it?
Solved! Go to Solution.
Not really because this is just a dummy example.. but I want to exclude any value from column B that appears in column A
but the result should be 3.. because I consider the 1 as a value... even if not repeated
Please look atention on my solution
you saying you want to show values from column1 where is not in column 2 correct ?
then my IF create value false where the values are iqual 😃
if i filter my page where this column is all ways true you will see 1,4 and 5 excloding 2 and 3
yes, your solution works in Power BI .. and I learned a new things!! thanks for that.. but I am looking a solution for power query. Let me try to create the same and I will let you know.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.
Visit our Community Blog for articles, guides, and information created by fellow community members.