Forum Discussion
Solved
One segment filter applied on two columns
Hello everyone, I would like to have the possibility to display information from my data however a date (year) is present in at least one of two columns with date. For exemple with the following...
you can try this.
1. create a new table for filtering (do not create relationship with your fact table)
Table 2 = DISTINCT( union(DISTINCT('Table'[Year1]),DISTINCT('Table'[Year2])))2. create a measure
Measure = if(max('Table'[Year1])=max('Table 2'[Year1]) || max('Table'[Year2])=max('Table 2'[Year1]),1)then add this mesure to the visual filter and set to 1pls see the attachment below
you can try this.
1. create a new table for filtering (do not create relationship with your fact table)
Table 2 = DISTINCT( union(DISTINCT('Table'[Year1]),DISTINCT('Table'[Year2])))
2. create a measure
Measure = if(max('Table'[Year1])=max('Table 2'[Year1]) || max('Table'[Year2])=max('Table 2'[Year1]),1)
then add this mesure to the visual filter and set to 1
pls see the attachment below