cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Microsoft
Microsoft

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.

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

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.

View solution in original post

Highlighted
Super User IV
Super User IV

Re: Values per selected filter in Slicer

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
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!

Highlighted
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.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors