Forum Discussion
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 am
What I did,
Measurecountitem =
var Measurecountitem=CALCULATE(DISTINCTCOUNT(sales[item]),ALLEXCEPT(sales,sales[item]))
return Measurecountitem
Column_Itemgrouping =
IF(sales[Measurecountitem]<10,"< 10",
IF(sales[Measurecountitem]>=10 && sales[Measurecountitem]<20,"< 20",
IF(sales[Measurecountitem]>=20 && sales[Measurecountitem]<30,"< 30",
IF(sales))))))))
when I am putting Column_Itemgrouping in column than only <10 shwoing other groups not coming, what is worng I am doing can somebody help me
yes as it will be give single value rsult
4 Replies
"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
Hi bilalkhokar73 ,
Has the problem be solved? If not, can you show some sample data and expected result to us so that we may be able to help you.
Best Regards,
Jay
yes solved , thank you
