Switch between % and absolute value

Hello,

I don’t know if there is any standard option like that, but there is a workaround that I can explain through a small example.

Assume we have a table named “Sales” with two fields.

The requirement is two show either the sales as absolute value or as percentage to total against each item.

We can achieve this functionality using the following method.

Step 1: Select “Enter Data” option and create the following table.

Step 2: Create the following measures.

Choice = SUM(Choice[Flag])

Note: If the value of Choice is 1, we will show absolute value. If choice = 2, then we will show percentage. If it’s 3, we will show blank (or the default option that you decide)

FigureToShow = 
IF( Choice[Choice]=1,
	SUM(Sales[Qty]),
IF(Choice[Choice]=2,
SUM(Sales[Qty]) / SUMX(ALL(Sales) , Sales[Qty]) *100,
BLANK() )
)

Step 3: Create a slicer using the DisplayChoice field which will have two options “Absolute Value” and “Percentage”

Based on the User’s choice, you will either get AbsoluteValue or Percentage as the result in the measure FigureToShow.

If the user choose AbsoluteValue the Matrix will show the following output

If Percentage is chosen, then the matrix will give the following output