Need Measure- SUM by TAG ID and respective sum along with
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%
