Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hi,
This is my Slicer
I need to figure out in this date range exist anywhere between these rows for each group#?
So I wanna say if
_Min_Date_Slicer is between Min(Inc_Start) and Max(Inc_Start)
__Max_Date_Slicer is between Min(Inc_End) and Max(Inc_End)
FILTER(
'Table', GROUP#=_GRP &&
_MIN_Date_Slicer >= MIN([INC_START]) && _MIN_Date_Slicer <= MAX([INC_START]) &&
_MAX_Date_Slicer >= MIN([INC_END]) && _MAX_Date_Slicer <= MAX([INC_END])
)
Can you help with this function? Thanks!
Solved! Go to Solution.
Found solution:
CALCULATE(SUMX(VALUES('TBL'[GROUP#]),1),
FILTER(
'Table', GROUP#=_GRP &&
(_MIN_Date_Slicer >= MIN([INC_START]) && _MIN_Date_Slicer <= MAX([INC_END])) ||
(_MAX_Date_Slicer >= MIN([INC_START]) && _MAX_Date_Slicer <= MAX([INC_END]))
)
)
Found solution:
CALCULATE(SUMX(VALUES('TBL'[GROUP#]),1),
FILTER(
'Table', GROUP#=_GRP &&
(_MIN_Date_Slicer >= MIN([INC_START]) && _MIN_Date_Slicer <= MAX([INC_END])) ||
(_MAX_Date_Slicer >= MIN([INC_START]) && _MAX_Date_Slicer <= MAX([INC_END]))
)
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 18 | |
| 11 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 26 | |
| 21 | |
| 14 | |
| 12 |