FILTER with SELECTEDVALUE using Slicer

[Yu_KK3128]

Hello,

FILTER using SECETEDVALUE() and visual Slicer dosen't work, perhaps I misunderstand something but my struggling goes for nothing...

Examples are below :

TABLE 1 has the columns ["ERROR", "MODEL", "SCORE"], and the measure named ["SELECTEDVALUE"] (showed by card) calculeted by

SELECTEDMODEL = SELECTEDVALUE(TABLE1[MODEL])

This measure varies depends on the slicer (looks working properly).

Then, I make TABLE2 with

TABLE2 = FILTER(TABLE1, TABLE1[MODEL]=CALCULATE([SELECTEDMODEL], ALLEXCEPT('TABLE1', TABLE1[MODEL])))

I want both SELECTEDMODEL(measure) and TABLE2 to change depends on the slicer, but TABLE2 won't change (show all rows of TABLE1)......

I try ALL, ALLSELECTED, but they also dosen't work.

Actually I want to make the difference of SCORE between TABLE1(filterd) and TABLE2 and show barchart of the difference.

How can I change the DAX or anythyng else??

Thanks in advance!

[amitchandak · Accepted solution]

@Yu_KK3128 , You can not use the slicer filter in new table creation.