Forum Discussion
Solved
Dax PowerPivot Adding Measure
Hi, need help with creating measure i'm trying to create a measure in powerpivot to add total of a measure to another measure. For example, in below table i want to add total of Internal measu...
Hi prash4030,
Measure is already an aggregation value so I'm afraid you can't aggregation measure again. As a workaround, you may convert measure [Internal] to calculate columns, than create a calculate columns using DAX formula below:
Final = VAR total = SUM('Table'[Internal]) VAR Own_RSD = CALCULATE(SUM('Table'[Owned]), FILTER(ALL('Table'), 'Table'[Category] = "RSD")) RETURN IF('Table'[Category] = "RSD", total + Own_RSD, total)You may also refer to the sample pbix file.
Regards,
Jimmy Tao
Hi prash4030,
Measure is already an aggregation value so I'm afraid you can't aggregation measure again. As a workaround, you may convert measure [Internal] to calculate columns, than create a calculate columns using DAX formula below:
Final =
VAR total = SUM('Table'[Internal])
VAR Own_RSD = CALCULATE(SUM('Table'[Owned]), FILTER(ALL('Table'), 'Table'[Category] = "RSD"))
RETURN
IF('Table'[Category] = "RSD", total + Own_RSD, total)
You may also refer to the sample pbix file.
Regards,
Jimmy Tao
thank you so much. it worked. thank you
