Need Measure- SUM by TAG ID and respective sum along with

[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-cazheng-msft]

Hi @NavaneethaRaju ,

You may try this Measure.

ActualTotal =
CALCULATE (
    [Total Procedures(TagLocation)],
    FILTER (
        'Tag Usage Fact',
        'Tag Usage Fact'[Order Date] >= MIN ( 'Tag Usage Fact'[Order Date] )
            && 'Tag Usage Fact'[Order Date] <= MAX ( 'Tag Usage Fact'[Order Date] )
    )
)

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 provide some sample data of your tables and the relationships between these tables. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun