Forum Discussion
Solved
Filter Related Table using inactive relationship
Hello, I am facing an issue whereby for a given dashboard, when filtering for a given value in a slicer, I need certain visuals to operate using an active 1-1 relationship whereas other visuals w...
After some playing around, the solution that I found was to add a calculated column in the FundDD table which serves as a flag to denote if that row is a department or not. I did this by doing a lookup on the Fund Code. This yielded the following table:
Fund Name Fund Code Department Abbr isDepartment Fund 1 FF001 FN 0 Fund 2 FF002 FN 0 Finance AA002 FN 1
By doing so, I was able to add the "isDepartment" column as a filter on visuals and by doing so, I was able to use the 1-many relationship and forgoe the 1-1 entirely.
louisGrivel , calculated columns and Tables can not use slicer values. You need to create measures that can use the slicer values.
Example measure
calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date]))
Is there an alternative method you could recommend to achieve a similar outcome?