Selectedvalue inside a row function

[technologyLMM]

Hi all,

I am having an issue when using the "selectedvalue" function inside a "row" function, as per below:

Actually, I am trying to filter "KYMA[Slip (%)]" column using a slicer (selectedvalue) for column "KYMA[Vessel]".

However I cannot get any results. 

In addition, I have noticed the following:

- if I remove this filter "KYMA[Vessel]", but keep the rest filters the formula is working.

- if I create a new measure with the same content, but outside union & row functions I get proper results (i.e. measure=calculate(AVERAGE(KYMA[Slip (%)])/100, KYMA[Wind Speed Abs. (knot)]<14,KYMA[Vessel]=selectedvalue(KYMA[Vessel] ))

Thank you in advance for your valuable assistance.

[technologyLMM]

Dear @Fsciencetech thank you for the reply. However this doesn't work.

Dear @PaulDBrown your reply is well noted and thank you. Actually, I want to create a table in order to use it in a radar visual. However, I understand that same cannot work in my case.

[PaulDBrown · Accepted solution]

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.

[Fsciencetech]

Hi,

Please use this option, hope you got correct result