Forum Discussion

DAX7800's avatar
DAX7800
New Member
2 years ago
Solved

Card not displaying correct filtered columns

Hello, I am new to DAX and measures but smart enough to know I need one in this issue. I have an excel spreadsheet I have created with 3 columns which move down from 3x Major League Baseball teams to the places they play, to their last names. a 4th column is the display card column. I have placed 1x filter on each column so I can move down the layers to view each step and a card which “should” display the filter selection as I go down. This does not work however as I move to the first column “TEAM” and select WSH, I would expect WSH to show up on the card, this does not happen. I believe it is because there are multiple WSH in the filtered column and therefore does not know which cell to show in the “display” column, and therefore I believe a measure is needed. If anyone can help me out with this issue I would really appreciate it.
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi DAX7800 ,

     

    You can combine multiple columns of filtering results with the help of the SELECTEDVALUE function. Try formula like below:

    Team Display =
SELECTEDVALUE ( 'Table'[TEAM ↑] ) & "-"
    & SELECTEDVALUE ( 'Table'[FIELD LOCATION] ) & "-"
    & SELECTEDVALUE ( 'Table'[LAST NAME] )

     

    Best Regards,
    Adamk Kong

     

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi DAX7800 ,

     

    You can combine multiple columns of filtering results with the help of the SELECTEDVALUE function. Try formula like below:

    Team Display =
SELECTEDVALUE ( 'Table'[TEAM ↑] ) & "-"
    & SELECTEDVALUE ( 'Table'[FIELD LOCATION] ) & "-"
    & SELECTEDVALUE ( 'Table'[LAST NAME] )

     

    Best Regards,
    Adamk Kong

     

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

    • DAX7800's avatar
      DAX7800
      New Member
      2 years ago

      Hi Adamk, 

      Thank you so much for your work, however when I used your formula it conected each filter as it went, where what i was looking for is "if the previous column was blank, then display the first column."

       

      using your "selected value" function (again, i'm new and couldnt figure out how to do this) I was able to use my EXCEL knowledge to come up with a working measure.

      This allowed me to identify the specific filter I was selecting and display it on a card.  Now I can show the header column in a Card and identify the data from the other columns in a table 

       

      Thank you for all your help, works great now!

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi DAX7800 ,

         

        Thank you very much for your feedback.😊

         

        Best Regards,
        Adamk Kong

  • DAX7800's avatar
    DAX7800
    New Member
    2 years ago

    This is a screen shot of my excel document, each column is a filter in my power bi. The "Naming Column" is the card which data i want displayed once a filter is selected. 

     

    How do i make a measure in DAX which states when one column is selected, to display the first cell in the "Naming Column" in sequential order?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi DAX7800 ,

     

    What do you expect the results to look like? Are there other filtering conditions?

     

    Best Regards,
    Adamk Kong