topic Re: Card not displaying correct filtered columns in DAX Commands and Tips

Card not displaying correct filtered columns

DAX7800 — Fri, 19 Apr 2024 16:08:14 GMT

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.

Re: Card not displaying correct filtered columns

DAX7800 — Fri, 19 Apr 2024 16:12:21 GMT

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?

Re: Card not displaying correct filtered columns

Anonymous — Mon, 22 Apr 2024 09:48:34 GMT

Hi DAX7800 ,

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

Best Regards,
Adamk Kong

Re: Card not displaying correct filtered columns

Anonymous — Mon, 22 Apr 2024 09:57:38 GMT

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.

Re: Card not displaying correct filtered columns

DAX7800 — Mon, 22 Apr 2024 15:52:05 GMT

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!

Re: Card not displaying correct filtered columns

Anonymous — Tue, 23 Apr 2024 01:38:37 GMT

Hi DAX7800 ,

Thank you very much for your feedback.😊

Best Regards,
Adamk Kong