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[country] ),
                                    CLINIC[country],", ", CLINIC[country], ASC ) )

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

RETURN

_Country & " | " & _Product

 

Without any selection the pipeline symbol should not be displayed.

 

Thanks in advance.

 

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.

8 Replies

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    Hi,

     

    On the Return change your formula to this:

    IF ( ISBLANK( _Product) && ISBLANK( _Country), BLANK(), _Country & " | " & _Product)

    • 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

    Hi AAndrade,

     

    Thanks for your response. Without any selection the pipe line delimiter has been hided. But when i select the country filter, the pipe line delimiter should not be displayed. If i select product, at that time that pipe line should be displayed.


    If i select product filter only the pipe delimiter should not be displayed.

     

    And one more if i select the dates between the range should be displayed From date and To date. Same pipe line scenario.

    We have lot of filter, how to displayed the full values in the object.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    I tested the solution provided by mark and it should meet your needs. If so, please mark it as the correct solution, and point out if the problem persists.

     

    Best Regards,
    Adamk Kong