Card not displaying correct filtered columns

[DAX7800]

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.

[v-kongfanf-msft · Accepted solution]

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]

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!

[v-kongfanf-msft]

Hi @DAX7800 ,

Thank you very much for your feedback.😊

Best Regards,
Adamk Kong

[v-kongfanf-msft]

Hi @DAX7800 ,

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

Best Regards,
Adamk Kong

[DAX7800]

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?