topic Re: Slicer not affecting measure in DAX Commands and Tips

Slicer not affecting measure

GAURAVG — Thu, 05 May 2022 08:38:21 GMT

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?

Re: Slicer not affecting measure

johnt75 — Thu, 05 May 2022 08:54:12 GMT

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]))

Re: Slicer not affecting measure

GAURAVG — Thu, 05 May 2022 11:41:36 GMT

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!!