Dear Team,

I have requirement like i have 3 tables Yearly table,Monthly, Original Transaction Table and have 5 global filters(Year,Month,Week,Country,Region).

If user passes  year selection value then we need to display measure from yearly table

If user passes  Month selection value then we need to display measure from Monthly table

If user passes other than (Year/Month) like country, week etc selection value then we need to display measure from Original Transaction table.

could you guys please help me how to create single calculated field to display data in one KPI based on user selections.

Thank you.