cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Count number of times value appears on different dates

Hello everyone!

I'm trying to produce a report that shows how many purchases a client has made on different dates, given that a person can make multiple purchases on the same day. This is what I'm trying to achieve:

1 ACCEPTED SOLUTION
Super User

Hi,

Drag Client to a Table visual and write this measure

Measure = Distinctcount(DetalleArreglos[Order Date])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
7 REPLIES 7
Super User

Hi,

Drag Client to a Table visual and write this measure

Measure = Distinctcount(DetalleArreglos[Order Date])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

That worked! Thanks a lot

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

Say, if your table has these columns "Order Date, Client Name, Order ID"

``````Count of Client Orders =
CALCULATE(
DISTINCTCOUNT('table'[Order ID]),
ALLEXCEPT('table', 'table'[Order Date], 'table'[Client Name],'table'[Order ID])
)``````

Frequent Visitor

I only have Order Date and Order ID. This is what I have in the actual model

Order Count = CALCULATE(
DISTINCTCOUNT(DetalleArreglos[Order ID]) ,
ALLEXCEPT(DetalleArreglos , DetalleArreglos[Order Date], DetalleArreglos[Order ID]))

Taking the first ID as an example, this is the raw information

The ID appears on 5 different dates and that is what I want the model to show.

Super User

Have sample raw data in Excel and copy, paste here.

Have expected data in Excel and copy, paste here.

Super User

CALCULATE(

COUNTROWS(yourtable),

ALL(youtable[dates])

)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors