Forum Discussion

technologyLMM's avatar
technologyLMM
Frequent Visitor
4 years ago
Solved

Selectedvalue inside a row function

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.

Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    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.

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    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.

  • technologyLMM's avatar
    technologyLMM
    Frequent Visitor
    4 years ago

    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.