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.
Hello All,
I am trying to find a solution for the following problem involving a some tables and multiple slicers. To simplify, I have the following table:
Group | ReadDate | MeterReading |
A | 201801 | 234 |
B | 201801 | 342 |
C | 201801 | 432 |
D | 201801 | 198 |
A | 201802 | 761 |
B | 201802 | 209 |
C | 201802 | 219 |
D | 201802 | 356 |
Both Group and ReadDate are in Text format. I have two slicers based on other related tables for Group and ReadDate. I can get the Group from multiple selection of one slicer - in the format A,C,D or A|C|D by the CONCATENEX function.
I got the selected value of ReadDate (single value) as a measure again from another Table Y. I created the relationship between all the Tables. Where the relationship is Many to Many, I created separate tables listing single values and relating this table to other tables creating One to Many relationship.
Now I want to apply both these measures as Filters on the above Table to get the SUM of MeterReadings.
I am not able to figure out how to apply multiple values of Group_Selected on the above Table to get a filtered table and then apply the Filter for the ReadDate on that table to get the SUM. I found that a post in the Forum suggested PATHCONTAINS function, but that is not working for me.
Please help me in suggesting a solution. Since I am not very proficient in Power BI, it will be helpful in explaining the various steps involved - probably create a table with one Filter, save as VAR table and then apply the second Filter to get the SUM.
Thanking you in advance.
Hi @kkanda ,
Can you please share a screesnhot on your data model and the relationships you have created?
Thanks,
Pragati
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 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |