Dax measure not working

[ROG]

Hi all,

Could you please tell me what I'm missing?

I want to know the number of sales partner that had at least 1 GA.

Thanks!

[FreemanZ · Accepted solution]

hi @ROG

try like:
POS =
CALCULATE(
   DISTINCTCOUNT('Sales Partner'[Sales Partner Code]),
   FILTER('Sales Partner', [Gross Addition Daily]=1)
)

if the issue persist, please consider providing more info about your sample data and model info (if multiple tables are involved)

[Mahesh0016]

@ROG  it is not work because u use Measure Expression for comparision .

GA>0 POS = calculate(Distinctcount(Table[column]),filter(table,[measure you use] > 1))

@ROG If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.