Forum Discussion
How to create new calculated table and filter it dynamically using measures
Hi Bhargav150 ,
The slicer visual can’t influence the calculated table.
Besides, try to calculate the measure to filter the new table.
Measure = var _date = SELECTEDVALUE(NewTable[SNAP_DATE]) RETURN IF(_date >= [Start Date] && _date <= [End Date], 1, 0)Then, set the show items is 1.
Viewing the following document to learn more information.
Using calculated tables in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Bhargav150 without model and details it is hard to spot issue.
Still, try v2 below
NewTable v2 =
VAR __Start_Date = Min('Date Table'[Date]
VAR __End_Date = Max('Date Table'[Date]
RETURN
SUMMARIZE (
FILTER (
query1,
query1[SNAP_DATE] >= __Start_Date &&
query1[SNAP_DATE] <= __End_Date
),
query1[ID],
query1[LN],
query1[AMT],
query1[CITY]
)
Not working 😔 some_bih
