Create a new measure/column that given a selection in a slicer filter in other 2 fields

[dpombal]

Given this initial customer dataset, I would like to have a single slicer on my report  for customer Type

Type	Interval	Status	Customer	Count
Low Performance	>90	Shipped	A	50
Low Performance	>90	Shipped	B	80
Low Performance	0-90	Cancelled	C	60
Low Performance	>90	Cancelled	D	40
Low Performance	>90	Shipped	E	30
Low Performance	0-90	Shipped	F	10
Regular	>90	Cancelled	G	200
Regular	0-90	Shipped	H	150
Regular	0-90	Shipped	I	150
Vip	0-90	Shipped	J	500
Vip	0-90	Shipped	K	800
Vip	>90	Sent	L	700
Vip	>90	Shipped	M	700

There is a single selection unique for customer type and as I show in previous values,

 IF SELECTED Type==Low Performance -->  Filter by Cancelled AND >90
 IF SELECTED Type==VIP --> Filter by  0-90  AND Shipped
 IF SELECTED Type==Regular -->  Filter by  0-90  AND Shipped

Here it is a the report pbix as demo

https://1drv.ms/u/s!Am7buNMZi-gwi3obfmZBgQ5yeIQ2

Low Performance Customers and filters

Vip customers and filters

regular customers and filters

[v-jiascu-msft]

Hi @dpombal,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

Hi @dpombal,

You can add a new calculated column. Then create a slicer with it.

ForSlicer =
IF (
    [Type] = "Low Performance"
        && [Status] = "Cancelled"
        && [Interval] = ">90",
    "Low Performance",
    IF (
        [Type] = "VIP"
            && [Interval] = "0-90"
            && [Status] = "Shipped",
        "VIP",
        IF (
            [Type] = "Regular"
                && [Interval] = "0-90"
                && [Status] = "Shipped",
            "Regular",
            BLANK ()
        )
    )
)

Best Regards!

Dale