Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Prodigy
Post Prodigy

Count Visit frequency (Week & Month)

Hi BI Community Team,


I have a table name "Customer Visit Plan -- CUST_VISIT_PLAN".


In this table, we want to find/calcualte how many customer that sales rep input to visit based on frequency below. Normally we count the visit date then we can find the number of visit plan of Month not week that actually they have number of visit in the week too.


For Week -- some sales rep add visit freq 2 or 3 time at the same week.



Here is the sample pbix file - 


Any suggestion?


Thanks and Regards,


Super User
Super User

I have the result as in the screenshot
Screen Capture #1211.pngScreen Capture #1213.png

Super User
Super User


Based on the tables that you have shared, show the expected result very clearly.

Ashish Mathur

Hi @Ashish_Mathur ,


We want to see the summary by sales rep as the screenshot below.




Please kindly check and help.


Thanks and Regards,

Super User
Super User

Your visit_freq table is missing an index column and it has conflicting buckets.  (the latter can be dealt with if you have the former).

Hi @lbendlin ,


For time/month, it should be as the screenshot below. But time/week, I don't know to add.




Please kindly help


Thanks and Regards,

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors