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.
Normal : revenue_BU = [revenue]/related(Rate[Exchange Rate]) in the case [Exchange Rate]=6.95
But Line 1: [revneue_Bu]= 603,668.6 / 6.95=86,858.79 <> 99,669.2 (calculate [Exchange Rate]=6.05672164 not equal 6.95)
Line 2 also mistake.
Line 3 to line 6 is correct
anyone face this issue. and how to solution.
Hi,
Can you try creating a new column with the IF Statement that you have and then use the SUM function. If the Related Function does not seem to work, you would need to make sure that the relationship should be properly configured between the Columns of the two tables.
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
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 |
---|---|
46 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
65 | |
50 | |
45 | |
20 | |
17 |