Forum Discussion
duynk
1 year agoNew Member
Problem when create a measure to display values based on the value that I select in the Filters pane
Hello! I am trying to create a measure to display values based on the value that I select in the Filters pane. For context, I have 3 tables: A, B, C Data in table A: Data in table B: ...
- 1 year ago
Hello!
You can try the measure without the FILTERS function, so:
DisplayFilterValue = CONCATENATEX( C, C[CC], ", ", C[CC], ASC )FILTERS function according to documentation "Returns the values that are directly applied as filters to columnName ". So even if only c1 is available, because theoretically you have selected ALL, it returns all values.
Hope this works for you.
JoBI
1 year agoResolver II
Hello!
You can try the measure without the FILTERS function, so:
DisplayFilterValue =
CONCATENATEX(
C,
C[CC],
", ",
C[CC],
ASC
)FILTERS function according to documentation "Returns the values that are directly applied as filters to columnName ". So even if only c1 is available, because theoretically you have selected ALL, it returns all values.
Hope this works for you.