Forum Discussion
bigSum from 2 sum data cards?
Hi derPatCIT21
Are 2 Sum Values both measures or aggregated column values? If they are two measures, say Measure1 and Measure2, you can create a third measure to get the SUM.
Measure3 = [Measure1] + [Measure2]
If they are column values using SUM to aggregate, you can create a new measure like
Measure4 = SUM('tableName'[columnName1]) + SUM('tableName'[columnName2])
Let us know if you have more details to add to your expected result.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
2 Replies
- Greg_Deckler
Community Champion
derPatCIT21 Not really enough to go on. Are those two visuals independent of one another? Are the slicers/filters being used the same or different columns?
- v-jingzhang
Community Support
Hi derPatCIT21
Are 2 Sum Values both measures or aggregated column values? If they are two measures, say Measure1 and Measure2, you can create a third measure to get the SUM.
Measure3 = [Measure1] + [Measure2]
If they are column values using SUM to aggregate, you can create a new measure like
Measure4 = SUM('tableName'[columnName1]) + SUM('tableName'[columnName2])
Let us know if you have more details to add to your expected result.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.