ItemGrouping

[bilalkhokar73]

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

[v-jayw-msft]

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

[bilalkhokar73]

yes solved , thank you

[daxer-almighty]

"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.

[bilalkhokar73 · Accepted solution]

yes as it will be give single value rsult