cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors