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.
I created calculated measure based on two calculated measures .
I am getting the SUM of that calculated measure 'new_revenue' wrong. I couldn't figure it out how to write an expression to SUM the calculated measure using DAX even after looking into forums.
Can any one help me with an expression to find the SUM of a calculated measure.
here expected sum is 2000 ( 200+1800 ) but value is coming like 3200 which 4000 * 0.8 . but i need exact sum .
someone please help me??
sample data :
previous_year_revenue | previous_year_exchange_rate | new_revenue = (previous_year_revenue) * (previous_year_exchange_rate) |
1000 | 0.2 | 200 |
3000 | 0.6 | 1800 |
sum = 4000 | sum = 0.8 | sum = 4000*0.8 = 3200 ( expected sum = 2000) |
Solved! Go to Solution.
I did say I can't because I don't know the model. Please take a s/shot of it and paste here. If you only want this to work for VISIBLE YEARS, then you'll need something like this:
sumx(
values( Table[Years] ),
[new revenue]
)
Best
D
Hi,
I am trying to figure out how to create a YTD SUM for a visual built from a calucated measure. The Sum I would like to see is S/S Variance YTD, can someone help me?
See snipshot below.
I did say I can't because I don't know the model. Please take a s/shot of it and paste here. If you only want this to work for VISIBLE YEARS, then you'll need something like this:
sumx(
values( Table[Years] ),
[new revenue]
)
Best
D
HI
Try like this. hope it will help u
table is a dummy name i used here and fact table are hidden from the slicer . i use only dimension slicer. i agree with ur suggestions, i need previous record of date as well , thats y i gave date there. currently i need sum of new_revenue .please help me to write that dax.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |