Different column output basing on Parameter Selection
Hi Guys and Welcome Everyone! my first post in this community :). I have following query. I have created parameter using "New Parameter" -> "Numeric Range" Then I have edited parameter settings as follows: Then I would like to have column with different output depending on parameter selection. I wrote formula as follows: When I test it in report view, I always get "NOTPASSED", whatever I choose in the slicer. Do I miss anything or is there other workaround to achieve my goal?
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.
