Slice value based on disconnected table with dynamic values
Hello, Is there a solution for the following problem? I have a measure ( a simple SUM) that is going to be displayed in a Matrix visual. I need to filter that value based on a selected version from a slicer. The issue is that the values from the slicer will change in time. So working with SWITCH ( hardcoded values) is not a solution. Is there a way to achieve a measure that is recalculated based on the user selection from a slicer? Now i have the fact table - containing the data used for the SUM and a disconnected table used for slicing the data.
