Forum Discussion

MTOnet's avatar
MTOnet
Icon for Helper III rankHelper III
7 years ago

Filter Data Table by a Measure

I am having some trouble finding a solution to my problem that I am trying to solve for a report I am working on. What I want to do is filter a data table by the result of a measure.  A solution is ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Perhaps try something like this for your measure:

 

Measure = 
VAR __selected = MAX('Table2'[Person])
VAR __detected = MAX('Table 1'[Detected])
VAR __assigned = MAX('Table 1'[Assigned])
RETURN
IF(__selected = __detected || __selected = __assigned,1,0)

Then add this measure to your Filters and filter for 1

MTOnet's avatar
MTOnet
Icon for Helper III rankHelper III
7 years ago

Hi Greg, thanks for the suggestion.  I was able to get the Detected and Assigned with what you provided, but the first part for  selected wasnt working.  I tried to display that on the data table, but when a record is selected, that column is blank.  I tried with my original measure that gets that value and I am seeing the wierdest behavior.  When I select a record from Table2, if I display my measure on a card, it displays the correct value for Person, but if i try to display that value on the data table, it shows as if no record is selected, so my comparison doesn't give the proper results,