Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Hi BI Community Team,
Please kindly help to support of this topic and suggestion.
Best Regards,
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |