Creating a slicer with others category

Question

Hello,I wish to create a slicer for currencies in my data. I wish some of the currencies to be listed explicitly e.g. (USD, GPB, CAD, CHF,...) and other currencies (e.g. MXN, RUB, CNY...) to be in 'Other' category and all the calculations are performed accordingly i.e. Sales with USD selected has total sales volume with ccy = USD where as when user selects 'Other' it is total sales of all the currencies in Other category.&nbsp;&nbsp;Which would be the most ideal way to go about it?

alsm · Accepted Answer

ok, figured it out ...&nbsp;steps involvedCreate a table with distinct currencys in the tableThen add a new column with a switch statement where one adds 'Others'Create a relationship with the original table for the filter to workDAX codeCcy List = ADDCOLUMNS (&nbsp; &nbsp; DISTINCT ( DataTable[Positions.Currency] ),&nbsp; &nbsp; "Currency Group",&nbsp; &nbsp; &nbsp; &nbsp; SWITCH (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRUE (),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Positions.Currency] = "CHF", "CHF",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Positions.Currency] = "USD", "USD",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Positions.Currency] = "EUR", "EUR",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Others"&nbsp; &nbsp; &nbsp; &nbsp; ))

Forum Discussion

Creating a slicer with others category

1 Reply

Related content

Creating date slicer removes data

Creating a dynamic slicer

category slicer

Create Categories

Average of categories over vendor