Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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% |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |