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]) , REMOVEFILTERS ( 'DimDate' ),FILTER(Propre,Propre[Statut]<>"PROPRE" ))
 

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

Need Help

1 Reply

  • 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