SELECTEDVALUE() is not supported in powerbi rs desktop

[Anonymous]

hi all,

   I'm creating a following measure in pbix file..

_TotR =
If(
SELECTEDVALUE('Focus'[Focus]) = "UP",
CALCULATE(COUNT('Gen'[Total]),'Gen'[Focus] <> "EXS"),
If(
SELECTEDVALUE('Focus'[Focus]) = "Exe",CALCULATE(COUNT('Gen[Total]),'Gen'[Focus] <> "ENG"),
CALCULATE(COUNT('Gen'[Total]))
)
)

this works good in powerbi desktop. but the same when i tried to implement in tabular model & powerbi rs desktop..

i'm facing issues(when dragged the measure into card).

after creating the measure in tabular model, it shows value for measure in model, but when i use the tabular model as source for powerbi rs desktop, i'm facing the above issue..if i drag measure to card.

Can anyone pls help, how can rectify it??

[v-yulgu-msft]

Hi @Anonymous,

Based on my test, SELECTEDVALUE() function worked fine in desktop optimized for Power BI Report Server. Please update your desktop version to the latest one: March 2018

Regards,

Yuliana Gu

[Anonymous]

Hi Yuliana Gu thanx for the reply..

  Using SELECTEDVALUE() i'm creating measure in powerbi report server desktop for which tabular model is the source. i didn't get selectedvalue() keyword at all...........so i'm using HASONEVALUE() instead of it..

[v-yulgu-msft]

Hi @Anonymous,

Yes. SELECTEDVALUE is not supported in Direct Query mode. Please see my reply in an other thread.

Regards,

Yuliana Gu