Forum Discussion
doubly value from distinct count with Positive Value
Hi Team, I need your help to get the Distinc count formula. i have data of Secondary sales . I need to see the product wise distinc Outlet count who have a positive sales. In our business Day 1 w...
The expected result of 4 for each, that is not counting the negative and 0's in your second table, correct?
In general, you would do something like:
Measure =
VAR _code = MAX([Product Code])
RETURN
COUNTROWS(FILTER(SUMMARIZE('Table',[Product Code],[Outlet Code],"__Qty",SUM([Qty])),[Product Code] = __code))
Hi Greg,
I have tried but it's not working. Pls. find the attached file how i create the measure.
Pls. help me solved it. Here the file link: " https://drive.google.com/drive/folders/1tT_Gi_ca2Q3AJgBWzH0Ne31ISVinHS0r?usp=sharing "
Regards,
Yeasin