Slicer not affecting measure

[GAURAVG]

Hello All,

I have a sample data of table below:

I want to create two measures:Assessment_1,Assessment_2.

Assessment 1 gives the values of assesment column based on selection in slicer1(PI).

Assessment 2 gives the values of assesment column based on selection in slicer2(PI).

I finlly want a table with LEVEL,NAME,ASSESSMENT1,ASSESMENT2 and Diff(Assessment1-Assessment2).

I crate separate measures for each,based on slicer..but the problem is the second measue gets affected by selection of slicer1 value.

TABLE1:

LEVEL	NAME	PI	ASSESSMENT
L1	aa	1	10
L1	bb	2	20
L1	cc	3	50
L2	df	1	12
L2	gg	2	15
L3	hj	1	15
L3	rr	2	12
L3	ty	3	50

My final result should be, for example if slicer 1 PI=2 and Slicer2 PI=3.

LEVEL	Assesment_Slicer1(PI=2)	Assessment_Slicer2(PI=3)
L1	20	50
L2	15	null
L3	12	50

Any help?

[GAURAVG]

Works perfectly. One part to be added is, you also need to remove interaction between the slicers to get the correct values.

Thanks a lot!!

[johnt75 · Accepted solution]

Rather than using the PI column in the slicers, create 2 new tables like

Slicer 1 = ALLNOBLANKROW('Table'[PI])

Slicer 2 = ALLNOBLANKROW('Table'[PI])

Don't link these to the main table, just use them on the slicers.

You could then create measures like

Assessment 1 = CALCULATE( SUM('Table'[Assessment]), TREATAS( VALUES('Slicer 1'[PI]), 'Table'[PI]))

Assessment 2 = CALCULATE( SUM('Table'[Assessment]), TREATAS( VALUES('Slicer 2'[PI]), 'Table'[PI]))