cancel
Showing results for
Did you mean:
Resolver I

Calculate SUM with two slicers

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.

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.

Thanking you in advance.

Super User

Hi @kkanda ,

Can you please share a screesnhot on your data model and the relationships you have created?

Thanks,

Pragati

My Blog: Data Vibe

If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements