Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

New Member

Automate the count of the total active clients( IN THE LAST 30 DAYS)

Hello guys good morning. I started working with Power BI in 2 weeks and my task here at the enterprise is to automate the weekly report that they need to send to the investors. Well I have a problem. In this segment of the report, I need to present the count of the total active clients( IN THE LAST 30 DAYS) . How I do this is simple. Just need to remove the duplicates and blanks from one specific column, in my table, and then use count rows and I have the Total number. I did that is easy, but the thing is that it need to be automatic, for example when I receive a batch of the last 7 days, automatically I need that total number without going to the table and repeat the process of remove duplicates and blanks and the count rows for that period of time.   What suggestions do you have? I have created the time table and I can with that use a slicer that give some specific 30 days of my database, but I need to create a measure or something that when I choose those 30 days automatically show me in a card for example the total active clients. ( remove duplicates + blanks , and the count the rows).

Thank you!


Hi @Casan3va,

Could you please post me some sample file and post your desired result if possible?



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.