How to FILTER only specific COLUMN

[Anonymous]

Hi Colleagues! Lots of usefull function work with columns, for example DISTINCTCOUNT. But amazing filter function FILTER returns TABLE. It would be great to shrink FILTER results to specific column to use with DISTINCTCOUNT, DISTINCT, COUNTA etc. Is it possible?

[amitchandak · Accepted solution]

@Anonymous ,not very clear.

example how can you use

calculate(DISTINCTCOUNT(Table[Column1]), filter(Table, Table[Column2] ="ABC"))

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.