Forum Discussion

ttmb's avatar
ttmb
Regular Visitor
8 years ago
Solved

slicing by a % measure

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 fr...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    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's avatar
    v-sihou-msft
    8 years ago

    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,

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

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