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
Icon for Microsoft Employee rankMicrosoft 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!

  • pejczi's avatar
    pejczi
    Frequent Visitor
    8 years ago

    Okay, I got another problem. I somehow modified the code :

     

    Forecast by partner = IF(NOT(ISFILTERED(Partners[Partners]));SUM('FR New'[Forecast]);SUM('FR New'[Forecast])*SELECTEDVALUE(Partners[Forecast%]))

    And it works fine. The thing is - I am using custom visual - HierarchySlicer. When I select a group of Partners, it does not sum selected group, it sums up all.