Forum Discussion
msksenthil
Helper III
5 years agoSELECTEDVALUE in row context
hello, the SELECTEDVALUE is not showing the selected value from the SLICER in the table visual. I would like to show the values of the selected Quarter and the previous quarter values. Thanks...
- 5 years ago
msksenthil , it should work unless columns are from disconnected tables
try like maxx(allselected(calendar),calendar[inserted Quarter])
- 5 years ago
Hi msksenthil
Try this.
Create the measure:
Chart Filter = VAR _maxdate = CALCULATE ( MAX ( 'Table'[MMMYY] ), FILTER ( ALL ( 'Table' ), 'Table'[InsertedQuarter] = SELECTEDVALUE ( 'Table 2'[InsertedQuarter] ) ) ) RETURN IF ( SELECTEDVALUE ( 'Table'[MMMYY] ) <= _maxdate, SELECTEDVALUE ( 'Table'[InsertedQuarter] ), BLANK () )Result:
Please check the sample file I attached below.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
5 years agomsksenthil , it should work unless columns are from disconnected tables
try like maxx(allselected(calendar),calendar[inserted Quarter])