Dynamic Filter: Use a SWITCH() inside a FILTER() function

Peter_Smit — Mon, 20 Nov 2023 12:10:09 GMT

Hi,

i have a table (with 1 column) which has 2 values:

NAV: Turnover Time => = #table({"Time Table"},{{"Current Year"},{"Other Period"}})

I have created a slicer to select one of the two values.
Based on the SELECTEDVALUE I would like to do some specific filtering:

TABLE: Turnover =

SUMMARIZE(

FILTER(

FACT_CUSTOMER_INVOICE_BI,

SWITCH(

SELECTEDVALUE('NAV: Turnover Time'[Time Table]),

"Current Year", YEAR(FACT_CUSTOMER_INVOICE_BI[INVOICE_DATE]) = YEAR(NOW()) // filters for the current year

)

FACT_CUSTOMER_INVOICE_BI[InvoiceFilter],

DIM_COMPANY_BI[CompanyFilter],

DIM_CUSTOMER_BI[CUSTOMER_NAME],

DIM_PROJECT_BI[ProjectFilter],

FACT_CUSTOMER_INVOICE_BI[INVOICE_DATE].[Year]

)

Result is an empty table while it should present al rows with invoice year is current year.

For some reason the result of SELECTEDVALUE() is empty ? while if I check this value as a card (visual) it returns "Current Year"..

What am I doning wrong?

Kind regards,

Peter

Re: Dynamic Filter: Use a SWITCH() inside a FILTER() function

Rupak_bi — Wed, 22 Nov 2023 10:29:36 GMT

A table cannot be dynamic. Only measures can.