Forum Discussion

pejczi's avatar
pejczi
Frequent Visitor
8 years ago
Solved

Values per selected filter in Slicer

Dear all,   Let's say that I've got a table :   Date             Forecast   Year  01.10.2018   1234         2018 01.11.2018   5125         2018 01.10.2018   5678         2019 01.11.2019   152...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi pejczi,

     

    Try this measure:

    Measure_1 = SELECTEDVALUE(TB1[Forecast])*SELECTEDVALUE(TB2[Forecast%])

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi pejczi,

 

Try this measure:

Measure_1 = SELECTEDVALUE(TB1[Forecast])*SELECTEDVALUE(TB2[Forecast%])

 

Best regards,

Yuliana Gu

pejczi's avatar
pejczi
Frequent Visitor
8 years ago

Hello,

 

Have you connected those tables by any kind of relationship? Unfortunately, this measure does not work for me - it does not show any values.

 

EDIT : It works after refresh. Thanks!