cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Resolver I

## SELECTED VALUE IS true When I select Two or three months

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

1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
3 REPLIES 3
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Memorable Member

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!

Super User

@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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors