Hi,
In the below example, I would need total for a new column as 1300 but individual row as 800, 500 group by header id. Thank you
1 ACCEPTED SOLUTION
Try this measure:
Header ID Total = CALCULATE ( SUM ( Table1[Revenue] ), ALLEXCEPT ( Table1, Table1[Header ID] ))
Try this measure:
Header ID Total = CALCULATE ( SUM ( Table1[Revenue] ), ALLEXCEPT ( Table1, Table1[Header ID] ))
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
