How to Calculate and Count the Repeat # of Time Order of Customer

[ADSL]

Dear BI Community Team,

Currently I am doing manually in pivot excel file to count distinct the Invoice number of customer and then filter and count.

Source file: https://drive.google.com/drive/folders/1EK-1SRY-P3R8AxDQhaqH84qebqnS9kdn?usp=sharing 

Please kindly advise the measure calculation how to do and count it in Power BI that I am new beginner.

Best Regards,

[ADSL]

Hi BI Community Team,

Please kindly help to support of this topic and suggestion.

Best Regards,

[amitchandak]

@ADSL , You will only get 70 in total not like you have shown, You have to segment you measure as I have shown in the video

Bucket/Segment code
measure = Countrows(Table)

bucket = Generateseries(1,7,1)

new Measure
Sumx(filter(Values(Table[Customer]), [Measure ] = max(bucket[Value])), [measure])

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[ADSL]

Hi @amitchandak ,

Thank you for your feedback. But I am a new beginner of Power BI so then I am trying to follow your measure provided, it's not working.

Could you please help to provide more detail guideline or doing sample in BI file?

Here is the source that I am trying: https://drive.google.com/drive/folders/1EK-1SRY-P3R8AxDQhaqH84qebqnS9kdn?usp=sharing