Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
"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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |