Forum Discussion
Solved
Measure as Gauge visual filter
Hi, For our sales dep. I'm working on a report in which we compare the signed and expected (hot) deals against the target. The idea is to have slicers in place to select the status of a deal (for...
Here are two approaches you might consider. Create a separate measure with the filter logic, and use a Fields parameter to allow the user to toggle between the base measure and the measure with the filter logic.
Alternatively, you could add columns to your fact table that correspond to the two disconnected tables. This would enable you to create relationships (the disconnected tables would become dimension tables in a star schema), allowing you to filter on Hot Deal, for example.
Hi DataInsights,
Thank you! The second alternative did work for us. We created a calculated column in the fact table and created a slicer for that.