Forum Discussion

duynk's avatar
duynk
New Member
1 year ago
Solved

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: ...
  • JoBI's avatar
    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.