When using SWITCH funciton to call other measures, returns BLANK() instead of "0"

[Miguel_Rojo]

Hi Community!

When I create a measure using the SWITCH() function that calls other measures depending of the selection in one slicer, the result shows as “Blank” values the “0” figure, Do you know how can I fix that?

Here’s a detail explanation:

1. The [Total Web Leads] measure is a simple sum of the “Leads” column:

1. The [LM Web Leads] measure is a simple sum of the “Leads” column, showing the “Last Month”:

1. The [%▲ MoM Web Leads] measure calculates the MoM growth:

If I use them directly in a Matrix, when the result is “0”, it shows “0” (that’s what I want):

But, when I use the next measure that “calls them” depending of the option selected in the Slicer, instead of “0” it shows BLANK(), do you know how can be solved that???

[Miguel_Rojo]

@DataInsights you're bloody great man

[DataInsights · Accepted solution]

@Miguel_Rojo,

Field parameters offer a better way to achieve this. Instead of using a SWITCH measure, simply add each measure to a field parameter. These measures will be available in a slicer, and the formatting of each measure will be used in visuals.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters