slicing by a % measure

[ttmb]

I have a Gross Margin % measure which is calculated from two other measures (Gross Margin $ divided by Total Sales $). I need to be able to slice/filter the report based on the percentage returned from the measure. For example: display only results with negative percentage, or only results with gross margin percentage above 20%.

I know that you cannot put measures in a slicer. Are there any other ways to accomplish this?

[parry2k · Accepted solution]

Create a summary table with % Margin and set relationship between summary table and data table and filter using % margin from summary table.

[v-sihou-msft · Accepted solution]

@ttmb

@parry2k is correct. To use the result of a mesure to slice/filter the context, you have to make this measure into a column. So you need to summarize this measure into a calculated table. 

CalculatedTable =
ADDCOLUMNS ( Table, "Gross Margin Pct", [Gross Margin %] )

Regards,

[pxg08680]

@ttmb

You can create a column using CASE/Switch statement or a IF statement according to your % values. Drop the calculated column into the slicer. Hope this solves your problem.

[parry2k · Accepted solution]

Create a summary table with % Margin and set relationship between summary table and data table and filter using % margin from summary table.