How to create a filter for a measure to (de-)select it in a combo chart

[TobiasWiegand]

Hi,

I have the following measure: 

**bleep**. PLAUF-Crisis Scenario = SUMX(FILTER(ALLSELECTED(Output[YYYYMM]), Output[YYYYMM] <= MAX(Output[YYYYMM])),[PLAUF - Crisis Scenario])

which is creating the orange line in below combo chart: 

Now I'm struggeling with creating a slicer to select- or deselect this measure for the chart so that when I publish the report, visitors can deselect the measure from the graph. How could I solve this?

Thank you very much for your help, highly appreciated.

Best

Tobias

[Anonymous · Accepted solution]

Hi @TobiasWiegand ,

Based on the information you provided, you can follow these steps:

1.Add new measure and new table.

orange =

IF ( ISFILTERED ( 'Table2'[select] ), [total], BLANK () )

2.Put [orange] in Line and clustered column chart, put 

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}