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
mickey
Frequent Visitor

How to keep existing filters while using calculate

Hi,

 

I have a table A which has the following fields: Episode, Start Date End Date

I have created another calculated table B which has a list of dates and I am trying to pull from table A how many episodes have a start date <= date in table B and a end date > date in table B.

 

I tried the following calculation:

Count =

VAR TableADate = 'TableA'[Date]
RETURN
    CALCULATE(
        COUNTROWS('TableA'),
        FILTER('TableA',
        'TableA'[Start Date] <= TableA
        && 'TableA'[End Date] > TableA     
    )
 
Though the above calculation is not working with a slicer I have for Table A. 
 
Thanks for the help.
2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

You should be writing a measure (not a calculated table formula).  Share some data in a format that can be pasted in an MS Excel file and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

@mickey , A slicer value can not be used in a calculated table

 

Consider these measure ways

 

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.