Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter Issue with Paginated Report

The paginated report, Issue. I need help with the power BI paginated report for user requirements. I have 6 parameters that are to be filtered on the report. Order No, Customer, Material No, MLFB,...
DAX
Paginated Report
Paginated Report Builder
PANEL
  • Anonymous's avatar
    Anonymous
    4 years ago

    Anonymous 

    Hello!

    RSCustomDaxFilter is a dynamic expression. Try transform it in general Dax-Code like FILTER() and add the OR() function.

     

    For example.
    RSCustomDaxFilter(@OpenSalesorderBUCode,EqualToCondition,[OpenSalesorder].[BU Code],String)) 

     

    Transfrom:

    FILTER(VALUES('OpenSalesorder‘[BU Code]), OR(('OpenSalesorder'[BU Code] = @OpenSalesorderBUCode), ('OpenSalesorder'[BU Code] = @OpenSalesorderBUCode)

     


    Paul Zheng _ Community Support Team

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous 

Hello!

RSCustomDaxFilter is a dynamic expression. Try transform it in general Dax-Code like FILTER() and add the OR() function.

 

For example.
RSCustomDaxFilter(@OpenSalesorderBUCode,EqualToCondition,[OpenSalesorder].[BU Code],String)) 

 

Transfrom:

FILTER(VALUES('OpenSalesorder‘[BU Code]), OR(('OpenSalesorder'[BU Code] = @OpenSalesorderBUCode), ('OpenSalesorder'[BU Code] = @OpenSalesorderBUCode)

 


Paul Zheng _ Community Support Team