Forum Discussion

derPatCIT21's avatar
derPatCIT21
New Member
5 years ago
Solved

bigSum from 2 sum data cards?

hi, how can i sum in Power BI 2 Sum Values for Datacards to a big sum?

 

  • 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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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's avatar
    v-jingzhang
    Icon for Community Support rankCommunity 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.