2 slicers from same columns

Hi Anonymous ,

Try the following steps:

step1,create two slicer base on status,and create slicer:

then create measure on slicer 2:

Measure = IF(MAX('Slicer 2'[status])=SELECTEDVALUE(Slicer1[status]),BLANK(),1)

Step 2,create measure on base data table:

SILCERchoosedatediff = 
VAR TIME1 =
    CALCULATE (
        MAX ( 'Table'[begin_date] ),
        FILTER ( ALL ( 'Table' ), 'Table'[status] = SELECTEDVALUE ( Slicer1[status] ) )
    )
VAR TIME2 =
    CALCULATE (
        MAX ( 'Table'[begin_date] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[status] = SELECTEDVALUE ( 'Slicer 2'[status] )
        )
    )
RETURN
    IF (
        TIME2 > TIME1,
        DATEDIFF ( TIME1, TIME2, MINUTE ),
        DATEDIFF ( TIME2, TIME1, MINUTE )
    )

 

Final you will get you want !

It would probably be much easier to just use a slicer, the following is just a reference：

onlyoneslicer = CALCULATE(DATEDIFF(min('Table'[begin_date]),MAX('Table'[begin_date]),MINUTE),ALLSELECTED('Table'))

 

 

Wish it is helpful for you!

 

Best Regards

Lucien

Hi Anonymous ,

Not very clearly.

Could you pls provide a sample?

Just for the table ,Slicer A choose value(begin_date):

2021-06-25 13:05:22

 And Slicer B choose value(begin_date):

2021-06-25 14:25:02

And you want to get the time between the two time?

 

 

Best Regards

Lucien

Hi Anonymous ,

Will different  call_num  with the same status? When this is the case, and a status corresponds to more than one beginning_date, calculate which datediff to choose.Need more details.

 

 

Best Regards

Lucien