IF with SELECTEDVALUE nothing selected give total

[Axiomite]

Hi there, 

Need help with the following. I have a card and a slicer. Currently the filter is applied to the calculation based on selected value in a slicer.
Currently looking like this:

CR Current = CALCULATE(SUM(table1[column]),

                                         FILTER (table1, table1[slicercolumn]= SELECTEDVALUE(table1[slicercolumn])))+0

However, currentl if nothing is selected it shows 0.

How can I change it to show the the result without the filter when nothing is selected? 

So IFomething is selected in the slicer then 

CALCULATE(SUM(table1[column]),

                                         FILTER (table1, table1[slicercolumn]= SELECTEDVALUE(table1[slicercolumn])))+0
      ELSE
          CALCULATE(SUM(table1[column])

Hope it makes sense.

Many thanks
         

[lukiz84 · Accepted solution]

Hi,

try:

RETURN

IF(HASONEVALUE(table1[slicercolumn]), <yourCodeFromAbove>, SUM(table1[column]))

hth and br

[Axiomite]

Thanks, getting a blank return.

[lukiz84]

Try

RETURN IF(NOT(HASONEVALUE(table1[slicercolumn])), SUM(table1[column]))

to see if it's your code that returns blank... (debugging) 

[Axiomite]

@lukiz84 
many thanks, the debugging as per above suggested works fine, it returns a value. However, re trying the first example I still get no value returned selecting or not selecting a value in the slicer.

[lukiz84]

Can you show the slicer Table (where you apply HASONEVALUE) and the data table? Just some sample data...?

[Axiomite]

@lukiz84 

Many thanks for your help. I'm terribly sorry for wasting your time. Whilst preparing sample data thus isolating the table from quite a "HUGE" report I been such a data rookie. In the end my issues was on of the fields having a data type as text rather than decimal number. However, strangely enough I got no error message, rather just no return.
Thanks for you time in helping me get to the bottom of the problem. I will go an accept your solution. Thanks again!