- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 =
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-10-2024 07:50 AM | |||
06-11-2024 06:30 AM | |||
Anonymous
| 03-22-2022 06:33 AM | ||
04-01-2024 05:36 AM | |||
05-22-2024 04:18 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |