I've a table listpuce (product)
epc0(subproduc)| categorie(product)
I calculate the frequency of each subprodduct in the fact table
I'd like to do a chart like that
This chart is based in the table hilighted which represents freqency already calculated by product
How to it please? Here's the pbix file https://1drv.ms/u/s!Amd7BXzYs7AVlXPjuP0CfblYyc5K?e=1b9DUX
i think you are looking for bucketing
Bucket/Segment code
measure
Measure = [Frequency Measure]
new Table
bucket = Generateseries(1,100,1)
new Measure
Countx(filter(Values(Table[user]), [Measure ] = max(bucket[Value])), [User])
refer
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Power bi New Feature Datamarts - https://youtu.be/8tskWsJTEpg
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
194 | |
68 | |
59 | |
58 | |
56 |
User | Count |
---|---|
185 | |
159 | |
88 | |
73 | |
70 |