Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi community,
I need to calculate the frequency of items i,e, distinct count of item sold in each month.
The description is as below:
What could be the DAX to calculate the frequency in that case. Any suggestions would be helpful.
Hi @FreemanZ
The sample data is the same as I provided in the image. The data is for the items sold in each month and if it is sold whatever the quantity is it will mark as 1 and the sum of all the months will be the final value (frequency).
hi @ScottWalter
it would be easier if you could also provide sample data to well reflect your case.