How to set a default measure when Variable is blank?

mwallman — Wed, 01 Nov 2017 15:20:12 GMT

Hello all,

The variable is called vButton.

I have two buttons based on the above variable:

Sales

Orders

I have the following expression in Measure:

If($(vButton)='Sales',

Sum(Sales),

If($(vButton)='Orders',

Count(distinct OrderID)

)

It works.

However I want to show Sum(Sales) when nothing is selected in the above buttons.

How can I get the expression to work so that if the variable has nothing then it shows Sum(Sales) values?

Re: How to set a default measure when Variable is blank?

kaushiknsolanki — Wed, 01 Nov 2017 15:31:19 GMT

Change code to below.

If($(vButton)='Orders',

Count(distinct OrderID),

Sum(Sales)

)

Regards,

Kaushik Solanki