Measure as Gauge visual filter

bertsolid — Wed, 15 Feb 2023 10:54:40 GMT

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 example, "signed, won") and to select if the deal is a hot deal or not. If the hot deal slicer is set to "yes", then the result set should show the deals with the selected statusses + all deals with hot deal = yes (regardless the status). So the slicers combined must use "OR" logic instead of the default "AND" logic. I'm trying to visualize the results (from table Query1) in a radial gauge visual.

To make this work I created 2 unlinked tables with the statuses and the hot deal boolean and a measure "FilterMeasure" with the following DAX:

FilterMeasure = CALCULATE((MAX(Query1[Status]) = SELECTEDVALUE(StatusTable[Status])) + (MAX(Query1[HotDeal]) = SELECTEDVALUE(HotDealTable[Value])))

The idea is to create slicers for the 2 unlinked tables and to add the measure as a visual filter with expression > 0.

The problem is that this approach isn't working for the Gauge visual. I can add the measure as a visual filter to the gauge, but I'm unable to set the parameters:

Using the measure as a visual filter on a table is working:

For sure the DAX command isn't correct, but I don't know how to write the DAX for the measure so that it can be used as a visual filter on a gauge visual. Or maybe the a complete different approach to achieve the goal to append records to the result set without considering the selected slicer value.

Hope someone can help me out.

Re: Measure as Gauge visual filter

DataInsights — Mon, 20 Feb 2023 14:16:45 GMT

bertsolid,

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.

Re: Measure as Gauge visual filter

bertsolid — Tue, 21 Feb 2023 07:07:10 GMT

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.

topic Re: Measure as Gauge visual filter in DAX Commands and Tips

Measure as Gauge visual filter

Re: Measure as Gauge visual filter

Re: Measure as Gauge visual filter