Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Current Selection Based on the Filter Selection

Hi All,   This is my current selection dax.   _Current Selection = VAR _Country = IF( ISFILTERED( CLINIC[country] ),                     "COUNTRY - " & CONCATENATEX(DISTINCT( CLINIC[coun...
Need Help
Tips and Tricks
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi,

    Please try this formula:

    _CurrentSelection = 
VAR _Country = "Country"

VAR _Product = "Product"

VAR _Region = BLANK()

VAR _Clinic = "Clinic"

VAR _SP = BLANK()

VAR _Gender = "Gender"

VAR _Age = BLANK()


VAR _Result = 
IF( 
    ISBLANK( _Country ) && ISBLANK( _Product ) && ISBLANK( _Region ) && ISBLANK( _Clinic ) && ISBLANK( _SP ) && ISBLANK( _Gender ) && ISBLANK( _Age ),
    "No Filters Applied",
    CONCATENATEX(
    {
        IF(NOT(ISBLANK(_Country)), _Country, BLANK()),
        IF(NOT(ISBLANK(_Product)) && NOT(ISBLANK(_Country)), " | " & _Product, IF(NOT(ISBLANK(_Product)), _Product, BLANK())),
        IF(NOT(ISBLANK(_Region)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product))), " | " & _Region, IF(NOT(ISBLANK(_Region)), _Region, BLANK())),
        IF(NOT(ISBLANK(_Clinic)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region))), " | " & _Clinic, IF(NOT(ISBLANK(_Clinic)), _Clinic, BLANK())),
        IF(NOT(ISBLANK(_SP)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region)) || NOT(ISBLANK(_Clinic))), " | " & _SP, IF(NOT(ISBLANK(_SP)), _SP, BLANK())),
        IF(NOT(ISBLANK(_Gender)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region)) || NOT(ISBLANK(_Clinic)) || NOT(ISBLANK(_SP))), " | " & _Gender, IF(NOT(ISBLANK(_Gender)), _Gender, BLANK())),
        IF(NOT(ISBLANK(_Age)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region)) || NOT(ISBLANK(_Clinic)) || NOT(ISBLANK(_SP)) || NOT(ISBLANK(_Gender))), " | " & _Age, IF(NOT(ISBLANK(_Age)), _Age, BLANK()))
    },
    [Value],
    ""
)
)
RETURN
_Result


    I did some tests and It's working properly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

This is my current selection dax. Need to be hided the pipe line with one selection, if multiple selection it should be displayed.

 

 

_Current Selection =

VAR _Country = IF( ISFILTERED( CLINIC[country] ),
                    "COUNTRY - " & CONCATENATEX(DISTINCT( CLINIC[country] ),
                                    CLINIC[country],", ", CLINIC[country], ASC ) )

VAR _Product = IF( ISFILTERED( CAREPLAN[Product] ),
                    "PRODUCT - " & CONCATENATEX(DISTINCT( CAREPLAN[Product] ),
                                    CAREPLAN[Product],", ", CAREPLAN[Product], ASC ) )

VAR _Region = IF( ISFILTERED( CLINIC[_F_Region] ),
                    "REGION - " & CONCATENATEX(DISTINCT( CLINIC[_F_Region] ),
                                    CLINIC[_F_Region],", ", CLINIC[_F_Region], ASC ) )

VAR _Clinic = IF( ISFILTERED( CLINIC[_F_Clinic] ),
                    "CLINIC - " & CONCATENATEX(DISTINCT( CLINIC[_F_Clinic] ),
                                    CLINIC[_F_Clinic],", ", CLINIC[_F_Clinic], ASC ) )

VAR _SP = IF( ISFILTERED( 'Date Table'[Date] ),
                    "SELECTED PERIOD - " & CONCATENATEX(DISTINCT( 'Date Table'[Date] ),
                                    'Date Table'[Date],", ", 'Date Table'[Date], ASC ) )

VAR _Gender = IF( ISFILTERED( PATIENT[gender] ),
                    "GENDER - " & CONCATENATEX(DISTINCT( PATIENT[gender] ),
                                    PATIENT[gender],", ", PATIENT[gender], ASC ) )

VAR _Age = IF( ISFILTERED( PATIENT[Age (groups)] ),
                    "AGE GROUP - " & CONCATENATEX(DISTINCT( PATIENT[Age (groups)] ),
                                    PATIENT[Age (groups)],", ", PATIENT[Age (groups)], ASC ) )

RETURN

IF( ISBLANK( _Country ) && ISBLANK( _Product ) && ISBLANK( _Region ) && ISBLANK( _Clinic ) && ISBLANK( _SP ) && ISBLANK( _Gender ) && ISBLANK( _Age ),
        "No Filters Applied",  _Country & " | "  & _Product & " | "  & _Region & " | "  & _Clinic & " | "  & _SP & " | "  & _Gender & " | "  & _Age  )  
_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Try this:

ISBLANK( _Country ) && ISBLANK( _Product ) && ISBLANK( _Region ) && ISBLANK( _Clinic ) && ISBLANK( _SP ) && ISBLANK( _Gender ) && ISBLANK( _Age ), "No Filters Applied",
IF(ISBLANK (_Country),,_Country & " | ") &
IF(ISBLANK( _Product),,_Product & " | " )&
...(Do the same for others filters)
 
For dates you can use the Min and Max function to define the initial and end dates.
After date out that option on the if condition.
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It is not working...

    • _AAndrade's avatar
      _AAndrade
      Resident Rockstar
      2 years ago

      Hi,

      Please try this formula:

      _CurrentSelection = 
VAR _Country = "Country"

VAR _Product = "Product"

VAR _Region = BLANK()

VAR _Clinic = "Clinic"

VAR _SP = BLANK()

VAR _Gender = "Gender"

VAR _Age = BLANK()


VAR _Result = 
IF( 
    ISBLANK( _Country ) && ISBLANK( _Product ) && ISBLANK( _Region ) && ISBLANK( _Clinic ) && ISBLANK( _SP ) && ISBLANK( _Gender ) && ISBLANK( _Age ),
    "No Filters Applied",
    CONCATENATEX(
    {
        IF(NOT(ISBLANK(_Country)), _Country, BLANK()),
        IF(NOT(ISBLANK(_Product)) && NOT(ISBLANK(_Country)), " | " & _Product, IF(NOT(ISBLANK(_Product)), _Product, BLANK())),
        IF(NOT(ISBLANK(_Region)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product))), " | " & _Region, IF(NOT(ISBLANK(_Region)), _Region, BLANK())),
        IF(NOT(ISBLANK(_Clinic)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region))), " | " & _Clinic, IF(NOT(ISBLANK(_Clinic)), _Clinic, BLANK())),
        IF(NOT(ISBLANK(_SP)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region)) || NOT(ISBLANK(_Clinic))), " | " & _SP, IF(NOT(ISBLANK(_SP)), _SP, BLANK())),
        IF(NOT(ISBLANK(_Gender)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region)) || NOT(ISBLANK(_Clinic)) || NOT(ISBLANK(_SP))), " | " & _Gender, IF(NOT(ISBLANK(_Gender)), _Gender, BLANK())),
        IF(NOT(ISBLANK(_Age)) && (NOT(ISBLANK(_Country)) || NOT(ISBLANK(_Product)) || NOT(ISBLANK(_Region)) || NOT(ISBLANK(_Clinic)) || NOT(ISBLANK(_SP)) || NOT(ISBLANK(_Gender))), " | " & _Age, IF(NOT(ISBLANK(_Age)), _Age, BLANK()))
    },
    [Value],
    ""
)
)
RETURN
_Result


      I did some tests and It's working properly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi AAndrade,

         

        This is working perfect..... Thanks for your support....