Forum Discussion

pelowski's avatar
pelowski
Icon for Helper III rankHelper III
4 years ago
Solved

DAX - Simple Table FILTER not working with SELECTEDVALUE

Here is a video showing what I'm trying to do... https://www.screencast.com/t/ii7Hcx8UlwT7   This is the simple code that I can't get to work. Table Filtered = FILTER('Table', 'Table'[Color] = S...
Need Help
  • pelowski's avatar
    pelowski
    4 years ago

    My colleague found a good solution to this problem.  It's definitely a work-around but it's better than the workaround I was using.

    Measure Code:

    SelectedEmail = IF(HASONEFILTER('Upgrade Details'[Email]), 1, BLANK())

    Then the Measure is added to the very end of the table, renamed to "_" (so it takes up minimal space) and the column is reduced so it can't be seen. The other columns have to be set to not aggregate. Now, the table on the right will only show data if a single email value is selected on the left. 😁

     

pelowski's avatar
pelowski
Icon for Helper III rankHelper III
4 years ago

My colleague found a good solution to this problem.  It's definitely a work-around but it's better than the workaround I was using.

Measure Code:

SelectedEmail = IF(HASONEFILTER('Upgrade Details'[Email]), 1, BLANK())

Then the Measure is added to the very end of the table, renamed to "_" (so it takes up minimal space) and the column is reduced so it can't be seen. The other columns have to be set to not aggregate. Now, the table on the right will only show data if a single email value is selected on the left. 😁

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Not bad.

 

Note that you can resize columns to make them effectively invisible (though you may need to turn off word wrapping on columns and values for it not to stretch the rows).