Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi community,
Pbix file for download --> https://1drv.ms/u/s!Agarkj-fHbLWjgkn-5Cm64lDbHgU?e=wWLi3Z
I need help with following measure. I have to create categories based on how many products consumed by ID in seletected period. So far I create this measure but I cannot use this measure as category.
My aim is count the total number products a customer had and create category for customers had only one, two , three, etc number of products. I want create following visual
I tried with columns but it is not dynamic so I want use measure. I would really appreciate for any given help
Many Thanks, C.
Solved! Go to Solution.
@Anonymous , You might have to do dynamic segmenetation
measure
NrOfProducts = Count(Table[productid])
new Table
bucket = Generateseries(1,100,1)
new Measure
Countx(filter(Values(Table[ID]), [NrOfProducts] = max(bucket[Value])), [ID])
You have plot the this bu series values
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
@Anonymous , You might have to do dynamic segmenetation
measure
NrOfProducts = Count(Table[productid])
new Table
bucket = Generateseries(1,100,1)
new Measure
Countx(filter(Values(Table[ID]), [NrOfProducts] = max(bucket[Value])), [ID])
You have plot the this bu series values
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Hi @amitchandak ,
One last quick question, If I have to create dynmaic grouping Like "single product user" and "Multi product user " then where to write if statement in above code.
Thanks you so much for your help!
C.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |