Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ,
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
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |