Forum Discussion

DPIT_FR's avatar
DPIT_FR
Regular Visitor
2 years ago

combine filter doesn't work (with parameters)

Hello all, I tried to filter a table with two filters, but it doesn't work (returns blank lines except for a curious total). My objective is to enable users to filter based on a threshold (with par...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi freginier ,Thanks for the quick reply, I'll add further.

Hi DPIT_FR ,

The Table data is shown below:

 

Regarding your question, please modify your measure according to the expression I provided.

MEASURE =
CALCULATE (
    SUMX (
        FILTER ( 'Table', 'Table'[Value] > 'Parameter'[Parameter Value] ),
        [Value]
    ),
    DATEADD ( 'Calendar'[Date], -1, YEAR )
)

Final output

 

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.