Need measure SUM for respective of tag ID with between data filters

[NavaneethaRaju]

Hi, 

I'm in middle of that one, i need to show the data and filter respective of slicer.

I wrote measure for sum of procedures respective of tag id, that worked on entire years of data.

whenever i select the date range, between that range it wont give sum value respective of tag id. 

I need measure to sum the procedures respective of tag id, as well as with between dates slicer.

Total Procedures(TagLocation) =
SUMX(VALUES('Tag Usage Fact'[Tag ID]),CALCULATE(SUM('Procedure Fact'[Procedures]),ALLEXCEPT('Tag Usage Fact','Tag Usage Fact'[Tag ID]),ALLEXCEPT('Sales Fact','Sales Fact'[Account ID])))

Figure 1: All year data for one tag id and its sum and percentage

When i applied the last 3 months relative date filter on slicer, it should show below like this

Figure 2:

Using that measures, this is not working respective of date filters. its display total for all time.
Actually its showing like this, I actually i want like Figure 2.

I enclosed the sample data and measures will indicate which are the fields and I'm using from which table

Tag ID	System Name	Set ID	Set Name	Order Date	Account	Tag Owner	No of Procedures	Total Procedures	% of Usage
4	AZ	1001	AZ SET	28-10-2020 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	01-12-2020 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	15-12-2020 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	31-12-2020 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	21-01-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	02-02-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	06-04-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	20-04-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	11-05-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	27-05-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	04-11-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	30-11-2021 00:00	Hospital 1	Alex	1	18	6%
4	AZ	1001	AZ SET	15-03-2022 00:00	Hospital2	Alex	4	18	22%
4	AZ	1001	AZ SET	12-04-2022 00:00	Hospital 3	Alex	1	18	6%
4	AZ	1001	AZ SET	14-04-2022 00:00	Hospital 3	Alex	1	18	6%

[v-cgao-msft]

Hi @NavaneethaRaju ,

Would you please provide some sample data (without sensitive data) and relationships about these three tables (Tag Usage Fact, Procedure Fact, Sales Fact)? A PBIX file would be nice. This is helpful to solve this problem. Thanks in advance!

How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data