SELECTED VALUE IS true When I select Two or three months

[sinanalmac]

 Hi ALL,
I wrote a calculation about a  slicer with a selected value function. Return false if  something is selected , return True  is something unselected.

her is my  calculation 

MTD TO = 
var MonthTest = SELECTEDVALUE(DistributorTarget[Month])

var  calc =IF(ISBLANK(Monthtest)=FALSE(),  CALCULATE(SUM(DistributorTarget[ActualValue])),
                           CALCULATE(SUM(DistributorTarget[ActualValue]),FILTER('Date','Date'[ThisMonthMTD] = 1),FILTER(DistributorTarget,Convert(DistributorTarget[Year],INTEGER)=YEAR(TODAY()))))

return calc

here is my true/false test example 

A_Test_False/True = 

var MonthTest = SELECTEDVALUE(DistributorTarget[Month])


var calc = IF(ISBLANK(MonthTest)=FALSE(),"false",

"true")

return calc

when  I selected One month or selected all,  it works.  But when I selected more  than one month it return true and it is like behavior for all months selected. I just want to calculate it  selected month's amount

How can I solve this issue? 

Best regards
Sinan 

[Anonymous · Accepted solution]

Hi @sinanalmac ,

Please be aware of that selectedvalue() function will return blank if there are multiple values selected.

In this case you could use COUNTROWS(VALUES(<columnName>)) = 1 or HASONEVALUE() function instead.

Best Regards,

Jay

[lukiz84]

what amitchandak said, but just to add a little info:

selectedvalue ONLY returns a value when there is ONLY ONE selected... thats why the results are correct!

[amitchandak]

@sinanalmac , You can use hasonevalue and isfiltered - https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Or you can check

countrows(allselected(Table[Month] )) >1