Forum Discussion
Post ProdigyIssue with DAX Calculations – Incorrect Results in Power BI
Hi harirao,
For division, [Order RSD] must be recalculated per row using CALCULATE + FILTER, and baseline fetched using LOOKUPVALUE, so both values align per row.
Regards,
Vinay Pabbu
Hi harirao,
Thank you for reaching out to Microsoft Fabric Community Forum.
Excel works with static rows, whereas Power BI measures operate within a dynamic filter context.
When you use a calculated column, it evaluates row by row, which aligns more closely with Excel behavior. However, when you use a measure like LOOKUPVALUE, it doesn't iterate row by row—it calculates based on the current filter context, which may not give you the expected results.
If you need to replicate row-by-row logic within a measure, consider using SUMX or another iterator function to explicitly control the row-level behavior.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu