Power BI Tips

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern  

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