Forum Discussion

Yu_KK3128's avatar
Yu_KK3128
New Member
5 years ago
Solved

FILTER with SELECTEDVALUE using Slicer

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!

 

1 Reply