Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DAX7800
New Member

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.
1 ACCEPTED SOLUTION
v-kongfanf-msft
Community Support
Community Support

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] )

vkongfanfmsft_0-1713779843958.png

 

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.

View solution in original post

5 REPLIES 5
v-kongfanf-msft
Community Support
Community Support

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] )

vkongfanfmsft_0-1713779843958.png

 

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.

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.

DAX7800_0-1713800708732.png

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 

 

DAX7800_1-1713801098812.png

Thank you for all your help, works great now!

 

 

Hi @DAX7800 ,

 

Thank you very much for your feedback.😊

 

Best Regards,
Adamk Kong

v-kongfanf-msft
Community Support
Community Support

Hi @DAX7800 ,

 

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

 

Best Regards,
Adamk Kong

 

DAX7800
New Member

DAX7800_0-1713542932175.png

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. 

 

DAX7800_1-1713543053646.png

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?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors