The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
So I'm new to DAX and I know this is pretty basic. I'm just trying to create a measure based on how many of the same numbers called during a period of time. On a separate visual show the top 10 using TOPN
My formula:
could you pls provide the sample data ? do you have a date table and filter the datetime?
Proud to be a Super User!
I don't have a table I can share, Its just a basic table with date, customer number, duration. If that helps. I appreciate your help
you can provide some dummy data. Otherwise, it's difficult to provide you the proper solution.
Proud to be a Super User!
Thanks for the help
what's the expected output?
Proud to be a Super User!
Just to show count by individual phone number and duration for each
what do you mean by count duration for each? could you pls provide the output screenshot based on the sample data you provided?
Proud to be a Super User!
User | Count |
---|---|
69 | |
69 | |
66 | |
55 | |
28 |
User | Count |
---|---|
112 | |
82 | |
66 | |
48 | |
43 |