Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

frequency by product

I've a table listpuce (product)   epc0(subproduc)| categorie(product)   I calculate the frequency of each subprodduct in the fact table  Fréquence = calculate(count(Propre[EPCs]) , REMOVEFILTER...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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