Dynamic static value

[AlanP514]

Hai guys need your help 

 I have challenge in dax could you please help  regarding this. Scenario is
If nothing selected from slicer or filter visual the card or the chart should give a static value 195 ,If user select any particular year or any filter they want to see the actual target value (actual data) for that particular area . ie if nothing selected static value. if they select slicer they want to see actual value in kpi card .could you please help me with this

[serpiva64 · Accepted solution]

Hi, you can try a measure like this

Measure = if (calculate(not IScrossFILTERED(factSales)),195,sum(factSales[ReturnAmount]))

It functions with direct and undirect filtering

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[AlanP514]

Thank you for your solution its working