Forum Discussion
Solved
ItemGrouping
I have one date table, itemtable and transaction table Sales I need to knwo that 1-10 item sold in how many shop 10-20 item sold in how many shop 20-30 item sold in how many shop , for me when I a...
yes as it will be give single value rsult
"CALCULATE(DISTINCTCOUNT(sales[item]),ALLEXCEPT(sales,sales[item]))"
The above is your problem. Look at this and think for a while what you're trying to do in there... I'll give you a hint: try to understand why the above always returns 1.
yes as it will be give single value rsult