Forum Discussion
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?
Hi pejczi,
Try this measure:
Measure_1 = SELECTEDVALUE(TB1[Forecast])*SELECTEDVALUE(TB2[Forecast%])
Best regards,
Yuliana Gu
4 Replies
Hi pejczi,
Try this measure:
Measure_1 = SELECTEDVALUE(TB1[Forecast])*SELECTEDVALUE(TB2[Forecast%])
Best regards,
Yuliana Gu
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!
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.
Hi,
What is the connecting column between the two? What result are you expecting?
