Multiple Filter need to be applied by condition

Hi jiangxm80  - 

The error thrown is stating that the ISBLANK function is being called without a required argument.  The argument could be a value or an expression to check for blank.  In your script, it looks like one of the variables @{variables('strVersionNo')}, @{variables('strProductGroup')}, or @{variables('strCategory')} might not be successfully resolved, which could be why the ISBLANK function is executing without an argument.

Here are some suggestions:

• Make sure the are correctly defined and values are being passed to the query, making sure that these are not null or empty.  You can do this by adding a step to view the values of these variables before using them in the ISBLANK function. 
• Modify the DAX script to confirm whether or not the variables are the cause of the problem or if it is something else, but replacing the variable values with some placeholder values. Below is an example of how you can do this. Replace "Version1", "ProductGroup1", and "Category1" with the actual values or ensure that the variables are correctly passed.

VAR __DS0FilterTable =
IF(
NOT(ISBLANK("Version1")),
TREATAS({"Version1"}, 'SalesForecastDetails'[VersionNo]),
BLANK()
)

VAR __DS1FilterTable =
IF(
NOT(ISBLANK("ProductGroup1")),
TREATAS({"ProductGroup1"}, 'SalesForecastDetails'[ProductGroup]),
BLANK()
)

VAR __DS2FilterTable =
IF(
NOT(ISBLANK("Category1")),
TREATAS({"Category1"}, 'SalesForecastDetails'[Category]),
BLANK()
)

VAR __DS0Core =
CALCULATETABLE(
SUMMARIZE(
'SalesForecastDetails',
'SalesForecastDetails'[YearNo],
'SalesForecastDetails'[MonthNo],
'SalesForecastDetails'[VersionNo],
'SalesForecastDetails'[Region],
'SalesForecastDetails'[Area],
'SalesForecastDetails'[ProductGroup],
'SalesForecastDetails'[Category],
'SalesForecastDetails'[SubCategory],
'SalesForecastDetails'[ProductNo],
'SalesForecastDetails'[ProductSpec],
'SalesForecastDetails'[FinalQty_Accum],
'SalesForecastDetails'[FinalAmt_Accum],
'SalesForecastDetails'[Left],
'SalesForecastDetails'[LeftAmt],
'SalesForecastDetails'[Sample],
'SalesForecastDetails'[SampleAmt],
'SalesForecastDetails'[Inv],
'SalesForecastDetails'[InvAmt],
'SalesForecastDetails'[FinalQty],
'SalesForecastDetails'[FinalAmt],
'SalesForecastDetails'[LInv],
'SalesForecastDetails'[LInvAmt]
),
KEEPFILTERS(__DS0FilterTable),
KEEPFILTERS(__DS1FilterTable),
KEEPFILTERS(__DS2FilterTable),
'SalesForecastDetails'[FinalQty_Accum] <> 0
|| 'SalesForecastDetails'[FinalAmt_Accum] <> 0
|| 'SalesForecastDetails'[Left] <> 0
|| 'SalesForecastDetails'[LeftAmt] <> 0
|| 'SalesForecastDetails'[Sample] <> 0
|| 'SalesForecastDetails'[SampleAmt] <> 0
|| 'SalesForecastDetails'[Inv] <> 0
|| 'SalesForecastDetails'[InvAmt] <> 0
|| 'SalesForecastDetails'[FinalQty] <> 0
|| 'SalesForecastDetails'[FinalAmt] <> 0
|| 'SalesForecastDetails'[LInv] <> 0
|| 'SalesForecastDetails'[LInvAmt] <> 0
)

EVALUATE
__DS0Core

Hi jiangxm80  , 

Thank you for reaching out to the Microsoft Fabric Forum Community.

1. your issue happens because you're applying a filter like keepfilters(__DS2FilterTable) even when __DS2FilterTable is blank.

2. In dax, that's not allowed — keepfilters(blank) doesn’t create a valid filter context, so it throws this error:
"the true/false expression does not specify a column."

3. To fix it, apply each filter only if it has a value. wrap each calculatetable step with if, instead of passing all filters at once.

If solution was helpful, please mark it as Accept Answer.

Feel free to let us know if you have any further questions—we’re here to help!