Values per selected filter in Slicer

[pejczi]

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   1525         2019

...

And another table would be like

Partner  Forecast%

X            10%

Y            50%

Z            40%

What I want to do, is that when I put the slicer and select a Partner, Forecast gets multiplied by Forecast%. Any ideas how to make a relationship , or any workaround?

[Ashish_Mathur]

Hi,

What is the connecting column between the two?  What result are you expecting?

[v-yulgu-msft · Accepted solution]

Hi @pejczi,

Try this measure:

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

Best regards,

Yuliana Gu

[pejczi]

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.

[pejczi]

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!