Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
@Anonymous ,
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
85 | |
85 | |
67 | |
49 |
User | Count |
---|---|
132 | |
113 | |
100 | |
68 | |
67 |