cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pejczi Frequent Visitor
Frequent Visitor

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   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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Values per selected filter in Slicer

Hi @pejczi,

 

Try this measure:

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

1.PNG2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

Re: Values per selected filter in Slicer

Hi @pejczi,

 

Try this measure:

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

1.PNG2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Values per selected filter in Slicer

Hi,

 

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

pejczi Frequent Visitor
Frequent Visitor

Re: Values per selected filter in Slicer

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 Frequent Visitor
Frequent Visitor

Re: Values per selected filter in Slicer

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.