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:
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.
VAR Group_Selected = CONCATENATEX( VALUES(Table X[Group]),[Group],"|"). By changing the delimiter to "," I can get the result as A,C,D.
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.