Forum Discussion

asjones's avatar
asjones
Icon for Helper V rankHelper V
3 years ago

DAX Table - Filter Based on Selected Value

I am tryign to create a dynamci table in DAX based on another table called 'Award Mater File'.  However I want  to create a new virtual/DAX table that is filtered based on the selected value from a s...
Need Help
asjones's avatar
asjones
Icon for Helper V rankHelper V
3 years ago

igrandey89 

 

Thanks for the response, I really appreciate it. I am not sure how I ended up with the 2nd table name.
I was using the selected value as I was trying to limit this table along with several other visuals with a slicer select 1. If multiple are selected here it is not critical as long as the visual is not to ugly with an error.

When i use your code I a system error

 

I tried to correct my table and it did not work either.

Table 3 =
CALCULATETABLE (
    'Award Master File',
    FILTER (
        'Award Master File',
        RIGHT ( 'Award Master File'[Award], 4 ) = RIGHT ( [Main Project # Selected], 4 )
    )
)

 

Any additional thoughts or guidance?

 

thanks

 

Alan