Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @pejczi,
Try this measure:
Measure_1 = SELECTEDVALUE(TB1[Forecast])*SELECTEDVALUE(TB2[Forecast%])
Best regards,
Yuliana Gu
Hi,
What is the connecting column between the two? What result are you expecting?
Hi @pejczi,
Try this measure:
Measure_1 = SELECTEDVALUE(TB1[Forecast])*SELECTEDVALUE(TB2[Forecast%])
Best regards,
Yuliana Gu
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |