The card visual is not displaying "all"

[LalitoBLM]

Hi,

I'm very new to PowerBI but I visit discussions on these forums for the great help in my development.

I'm working on a simple report to display and filter instruments by type showing the count for each. I have used the following code to seach Column1 for values Value1 and Value2 and assign ValueA to them under the JointInstType:

JointInstType = IF(
	ISERROR(
		SEARCH("Value1", Table1[Column1])
	),
	IF (ISERROR(
		SEARCH("Value2", Table1[Column1])
	),
FIRSTNONBLANK(Table1[Column1], 1),
"ValueA"),
	"ValueA"
)

The report works; however, the for the "select all" slicer it displays ValueA which should display "All".

How do I change the code to display all?

I appreciate your help.

[nandukrishnavs]

@LalitoBLM 

Try below DAX.

JointInstType =
IF (
    ISERROR ( SEARCH ( "Value1", Table1[Column1] ) ),
    IF (
        ISERROR ( SEARCH ( "Value2", Table1[Column1] ) ),
        FIRSTNONBLANK ( Table1[Column1], 1 ),
        "ValueA"
    ),
    IF ( NOT ( ISFILTERED ( Table1[SlicerColumn] ) ), "All", "ValueA" )
)

If this is not working then please share the PBIX file or sample input table and expected output.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂