Is it possible to create a calculation in which part of the calulation isnt affected by an attribute

Question

I have number of cars sold and total number of cars sold as 2 measures and sales channel as an attribute

Number of cars sold/total number of cars sold as my calulation and sales channel as a dashboard filter, this will equal 1 when the dashboard filter inst being used.

Is it possible to have sales channel filter the 'number of cars sold' but not the 'total number of cars sold'

Chere-Oracle · Answer

Sorry, LukePa.  Since you wrote "dashboard filter," I assumed you were using classic, which includes dashboard prompts.

In your case, it has to be a parameter, not a variable.  The parameter name (e.g., sales_channel) can be inserted in the calculation like this:

FILTER( "Cars Sold" USING ( "Sales Channel" LIKE '@parameter("sales_channel")' ) ) / "Cars Sold"

LukePa · Answer

Hi @Gianni Ceresa , this is for a DV workbook.

Gianni Ceresa · Answer

@LukePa , what part of the product are you using? DV workbook? A "classic" analysis and dashboard? A Publisher report?

The answer could change based on that…

By "set a presentation variable name in the dashboard board", she means that because you can't filter the whole query by your "sales channel" (as that's the reason you are asking the question) you need to have access to the value selected by your users through a variable. Therefore you modify your prompt/drow-down list/dashboard filter to set a variable with the value of the selected sales channel.

Then you can reference that variable in the expression of the column for "Number of cars sold".