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.
Hi Experts,
I need to find the Current Row Column Value in Measure ( NOT Calculated Column) .
Am Having a DAX :
Solved! Go to Solution.
@chris_sam
So you need the total corrected? I hope the line amounts are giving the YTD correctly.
Try this measure:
YTD_FINAL =
IF( HASONEVALUE('table'[zzmatnr]),
CALCULATE(
SUM('table'[sales] ),
FILTER(
ALLEXCEPT('table','table'[zzmatnr] ),
'table'[month] <=MAX('table'[month]) , 'table'[Year] = MAX('table'[Year]) )
),
SUM('table'[sales] )
)
________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You cannot use the EARLIER function in this context,
To get the result you are expecting, modify your measure this way:
YTD_FINAL =
CALCULATE(
SUM('table'[sales] ),
FILTER(
ALLEXCEPT('table','table'[zzmatnr] ),
'table'[month] <=MAX('table'[month]) , 'table'[Year] = MAX('table'[Year]) )
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy I tried you Measure.. Am Getting Wrong Value when am Using Two Years..
YTD Calc Grand Total Should be : 70
Please Check with Screenshot... its not Working out..
@Anonymous
Can you show the expected results and explain please
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This The 2018 month Value (Working Fine) :
This is 2019 Month 1 value :
Value which i need in Grand Total is 185 + 35 = 220 ... Value which am getting is 65 (ie . SUM of Year 2019 1st month , 7th Month and 13 Month which is am not even selected in Slicer .. i selected 2018 all months and 2019 1st Month Only)
@chris_sam
So you need the total corrected? I hope the line amounts are giving the YTD correctly.
Try this measure:
YTD_FINAL =
IF( HASONEVALUE('table'[zzmatnr]),
CALCULATE(
SUM('table'[sales] ),
FILTER(
ALLEXCEPT('table','table'[zzmatnr] ),
'table'[month] <=MAX('table'[month]) , 'table'[Year] = MAX('table'[Year]) )
),
SUM('table'[sales] )
)
________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Its also Taking The Sum of 1st Month of year 2018 Sales value with 1st Month 2019 Sales value
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |