Parameter Table

https://www.daxpatterns.com/parameter-table/ 

Use slicer to select whether to optionally divide sales amount by 1,000 or 1,000,000.

Scale Table - show Scale string in slicer

Scale =

DATATABLE (

"Scale", STRING,

"Denominator", INTEGER,

{

{ "Units", 1 },

{ "Thousands", 1000 },

{ "Millions", 1000000 }

}

)

Measure - divide sales amount by Denominater for the slicer string selected. Use 1 if nothing selected or multiple selections.

Sales Amount =

VAR RealValue =

SUMX (

Sales,

Sales[Quantity] * Sales[Net Price]

)

VAR Denominator =

SELECTEDVALUE (

Scale[Denominator],

1

)

VAR Result =

DIVIDE (

RealValue,

Denominator

)

RETURN

Result