cancel
Showing results for
Did you mean:

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

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
Helper IV

yes as it will be give single value rsult

4 REPLIES 4
Community Support

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.
Helper IV

yes solved , thank you

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.

Helper IV

yes as it will be give single value rsult

Announcements

#### 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 Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors