Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
bilalkhokar73
Helper IV
Helper IV

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

1 ACCEPTED SOLUTION

yes as it will be give single value rsult 

View solution in original post

4 REPLIES 4
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

yes solved , thank you

daxer-almighty
Solution Sage
Solution Sage

"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 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.