Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Create Slicer based on four fields.

I am new to BI and was hoping someone could provide a solution to the following:   I have a dataset that includes thousands and thousands of rows of order level detail. Within this data I have info...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Anonymous

 

According to your description, I assume you have a table as below.

 

 

You can create a new table which includes a column for pricing schedules selection. Then you can get the expected result by create one measure. Please refer to following steps.

 

  1. Create a new table for pricing schedules selection

  2. Create a measure to calculate the profitability according to the slicer selection.
    Profitability = 
IF (
    HASONEVALUE ( Schedules[Schedules] ),
    SWITCH (
        VALUES ( Schedules[Schedules] ),
        "A", SUM ( Price[Pricing Schedules A] ) - SUM ( Price[COGS] ),
        "B", SUM ( Price[Pricing Schedules B] ) - SUM ( Price[COGS] ),
        "C", SUM ( Price[Pricing Schedules C] ) - SUM ( Price[COGS] ),
        "D", SUM ( Price[Pricing Schedules D] ) - SUM ( Price[COGS] )
    ),
    BLANK ()
)