How to modify this to show all values when filter selects ALL

[JustinDoh1]

Sorry. I am posting this again because I did not get the solution from my last post which I started asking from last Friday.

I have my latest PBIX file here.

What I am trying to do is, when ALL Locations are selected, I would like all three visuals show up, but current DAX would

not do it or I am not sure if there is any way to make it work with PowerBI.

I have three individual DAX for each of threes (ALI, ARB & AVI).

Examples (for ALI and ARB, skipping for AVI):

How do I make it work to have all three visuals would show the characters when user selects ALL three locations?

Thanks.

[Anonymous · Accepted solution]

Hi,  @JustinDoh1 
Thanks for reaching out to the Microsoft fabric community forum.

The issue you are currently facing is primarily due to the ISFILTERED() function always returning true, even when the location column filter is not clicked. Therefore, we can resolve this issue by using a new table as a slicer:

1.Firstly, you need to create a new calculated table to be used as a slicer, and ensure that this new table has no relationships with other tables:

Z-Table = VALUES('tblScore'[Location])

2.Secondly, create the following measures and replace the card visual objects accordingly:

ALI1 = 
IF (
    ISFILTERED ( 'Z-Table'[Location] ),
    IF (
        CONTAINSSTRING ( CONCATENATEX ( 'Z-Table', 'Z-Table'[Location], "," ), "ALI" ),
        "ALI",
        ""
    ),
    ""
)

ARB1 = 
IF (
    ISFILTERED ( 'Z-Table'[Location] ),
    IF (
        CONTAINSSTRING ( CONCATENATEX ( 'Z-Table', 'Z-Table'[Location], "," ), "ARB" ),
        "ARB",
        ""
    ),
    ""
)

AVI1 = 
IF (
    ISFILTERED ( 'Z-Table'[Location] ),
    IF (
        CONTAINSSTRING ( CONCATENATEX ( 'Z-Table', 'Z-Table'[Location], "," ), "AVI" ),
        "AVI",
        ""
    ),
    ""
)

3.Next, create the following measures to be used as filters for the table visual objects:

FILTER = 
IF (
    ISFILTERED ( 'Z-Table'[Location] ),
    IF ( MAX ( 'tblScore'[Location] ) IN VALUES ( 'Z-Table'[Location] ), 1, 0 ),
    0
)

4.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JustinDoh1]

@Anonymous 

Sorry, I have one more requirement now:

Bottom is a new post that I just posted:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-modify-this-to-show-all-values-when-filter-selects-ALL/m-p/4345285#M172551

[JustinDoh1]

@Anonymous I think this should work. I will try and let you know if there is any issue (from my manager). Thanks!