topic Dax measure not working in DAX Commands and Tips

Dax measure not working

ROG — Wed, 18 Jan 2023 10:17:11 GMT

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!

Re: Dax measure not working

Mahesh0016 — Wed, 18 Jan 2023 10:28:39 GMT

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.

Re: Dax measure not working

FreemanZ — Wed, 18 Jan 2023 14:57:21 GMT

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)