Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
@gerasimovav ,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.
@gerasimovav ,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.
User | Count |
---|---|
44 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |