Forum Discussion
Selectedvalue inside a row function
SELECTEDVALUE referring a slicer will not work when creating a physical table as you are trying to do. Physical tables are calculated when the model is loaded and are oblivious to slicers. You will need to create the "table" using a table visual or matrix (with the latter you can create the layout you want using the option "Show on rows" under Values in the formatting pane, which will place the measures as rows.
Community ChampionSELECTEDVALUE referring a slicer will not work when creating a physical table as you are trying to do. Physical tables are calculated when the model is loaded and are oblivious to slicers. You will need to create the "table" using a table visual or matrix (with the latter you can create the layout you want using the option "Show on rows" under Values in the formatting pane, which will place the measures as rows.