Forum Discussion
Solved
Distinctcount variable if
Buenas tardes, Soy principiante en PBI, y hasta ahora, he podido ir solucionando todos los problemas que se me han ido presentando. Pero en esta ocasión, llevo 3 ó 4 semanas y no hay manera de encon...
Hi JavierGomez
What do you mean by A and B?Here's the sample:
Table:
The _Count measure is:
_Count = DISTINCTCOUNT('Table'[Values])And it returens:
Then add a Measure:
Measure = IF([_Count]<=5,"A","B")The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JavierGomez
What do you mean by A and B?
Here's the sample:
Table:
The _Count measure is:
_Count = DISTINCTCOUNT('Table'[Values])And it returens:
Then add a Measure:
Measure = IF([_Count]<=5,"A","B")The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.