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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JAJ
Regular Visitor

Need help to count rows within period from a single Date Slicer based on two date columns

Hi There,

 

I have the following setup, Tables Item and Date. The Date table serves as a Date Dimension, on which I will setup a single slicer.

JAJ_1-1626898954957.png

 

I've added 2 measures as follows that work well. The First is to show a count of Items that started within a selected period:

 

JAJ_2-1626899269574.png

The second measure show a count of Items that ended in a selected period:

JAJ_3-1626899333206.png

This makes use of the secondary relationship.

 

However, I am looking to add a measure for those records that are Started and Ended within a selected period.

JAJ_4-1626899416249.png

 

From the above rows I expect the following results:

JAJ_5-1626899439315.png

Can any one assist with this DAX expression?

 

 

 

 

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

2 REPLIES 2
JAJ
Regular Visitor

Worked like a charm! Kudos @wdx223_Daniel 

wdx223_Daniel
Super User
Super User

wdx223_Daniel_0-1626925347046.png

wdx223_Daniel_1-1626925379511.png

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.