Hi All,
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
A- Value | B-Exclude |
1 | 1 |
2 | |
1 | |
2 | |
3 | |
3 | |
4 |
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?
thanks
Simone
Solved! Go to Solution.
i forget to add formula where
you can create a new column and filter the page base on true 😃 or another way around
hope this it will help
Not really because this is just a dummy example.. but I want to exclude any value from column B that appears in column A
Result:=CALCULATE(COUNT(Table1[Simone]),FILTER(Table1,Table1[Simone]<>Table1[Exclude]))
but the result should be 3.. because I consider the 1 as a value... even if not repeated
example
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.
the same think but in mesure 😃 is this you want ?
i forget to add formula where
I thought I was answering... thank youuu soooo much!!! worked magically 🙂
Chapeau!!!!!!!!!!!!!
the same as your exemple 😃
@simo12447 , try
calculate(distinctCOUNT(Table[A]), Table[B]<>1)
OR
calculate(distinctCOUNT(Table[A]), filter(Table,Table[B]<>1))
thanks @amitchandak ... but I want to add to any value in column B .. not only 1 since it is an example.
Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
365 | |
96 | |
64 | |
54 | |
38 |
User | Count |
---|---|
356 | |
110 | |
72 | |
60 | |
50 |