Can I add the sum of two visuals?

[Anonymous]

Hi all,

I am a new user to Power BI and and looking for help.

I am looking to add the total from a Table Visual and the value from a Data Card Visual to give me a grand total.

Both visuals are created with filters

I am looking to create a data card showing a total of 15,926

I don't even know if what I am asking is possible

Any help would be great

[v-frfei-msft]

Hi @Anonymous ,

One sample as below. Here we can create a measure to work on it.

Measure = SUM('Table'[Volume])+SUM('Table'[withdrawn])

[Anonymous · Accepted solution]

Hi @v-frfei-msft 

I recreated the two visuals through Dax, and was able to get the desired outcome:

Total_Withdraw =

Calculate(

    SUM('SHEET1_UPDATED_WEEK24'[count]),

    NOT 'SHEET1_UPDATED_WEEK24'[New_Payment_Method] IN{"DD-CPS","DD-VDD"},

    'SHEET1_UPDATED_WEEK24'[old_payment_method] IN {"DD-CPS","DD-VDD"},

    'SHEET1_UPDATED_WEEK24'[pivot]="contract movement")

+

Calculate(

    sum('SHEET1_UPDATED_WEEK24'[count]),

    'SHEET1_UPDATED_WEEK24'[pivot]="accounts withdrawn")

Thanks for your help