Dynamic Country Filter

[ringovski]

Hi All,

I was wondering if it is possible to make a dynamic filter based on a selected country and update a matrix table based on it.

Countries are broken into Selected Country, All Countries, Rest of World (all-selected). Obviously the selected country changes as per user selection from a filter\slicer.

Data structure is a pretty simple star schema with fact table and related dimesions,Dim_Date, Dim_Product, Dim_Country etc.. join on Country_sk to Country id. 

Export_Fact_Codes
calendar_sk	country_sk	loading_sk	discharge_sk	product_code_sk	state_sk	quantity_sk	value$
300	100	1	600	121	1	400	1328967
300	101	1	601	121	2	600	84353905
300	102	2	603	121	2	800	41839
301	100	1	600	121	2	900	12888454
301	101	2	601	121	3	1000	27880729
301	102	2	602	121	3	200	230237

Dim_Country
CountryID	Full_Country_Name
100	Afghanistan
101	Albania
102	Algeria
103	Angola
104	Australian Antarctic Territory
...	...

Requested Matrix Table

Product_Code	2022	2022	2022
	All Countries	Selected_Country	Rest of World
code 110	1916114	844496	1071619
code108	73693	68878	4816
code101	11571	13371	98201

I can do it for a single selected country by adding a additional conditional column in the Dim_Country, 'Groupings'  China = China ELSE 'Rest of World'. The diffcult part is changing the selected country dynamically.

Thanks for any assistance.

[Idrissshatila]

Hello @ringovski ,

Check if this video will help in your case https://youtu.be/nWgPynP9XDM?si=6cdpqmFptOFgBkLb

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡