Forum Discussion
Solved
Can´t display the visual
Hi everyone, I hope this message finds all of you fine, I´m trying to do a specific report, but I stopped here because of this issue on a measure. It work for a specific case but doesn´t work...
Hi QLDPETER10 ，
According your dax ,I think your error is on coord<>"8445".Because when using Allselected, the slicer selects multiple values, the result is equivalent to a collection, which cannot be equated directly, a conversion is required, see the example below.
Refer the below sample:
test = VAR ALLSELECTED1 = CONCATENATEX ( ALLSELECTED ( 'Table' ), 'Table'[Type], "," ) RETURN IF ( ISERROR ( SEARCH ( "A", ALLSELECTED1 ) ) = FALSE (), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table' ) ), CALCULATE ( SUM ( 'Table'[Value] ), ALLSELECTED ( 'Table' ) ) )Output:
To leanr more details ,refer:
CONCATENATEX
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
amitchandak
Super User
Super UserQLDPETER10 , Click on see details and share the error. That can help to find the error
Ok, Thanks for answer me,
The pop up window is :
Do you need the information that I can copy to my clipboard?