table totals sum displayed in Card

[Anonymous]

I have a table that is totaling a column at the bottom using the formula:

Extended Item Cost Measure = 
SWITCH(
          TRUE(),
CALCULATE(COUNTROWS(POP10100),RELATEDTABLE(SOP10200))<=0, CALCULATE(SUM(DocumentItems[ExtendedCost]),RELATEDTABLE(SOP10200),DocumentItems[ItemType_All]="Product"),
          SELECTEDVALUE(SOP10200[QUANTITY])=1, SUMX(POP10110, POP10110[UNITCOST]),
          SELECTEDVALUE(SOP10200[QUANTITY])>1, SELECTEDVALUE(POP10110[UNITCOST]) * SELECTEDVALUE(POP10110[QTYORDER])
         )

I need to display the total from one of the summed columns in a card on a different page. I thought I could use the same formula, but it doesn't work.

Is is possible to just copy the table total from the summed up column to a card?

Thanks,

[v-juanli-msft]

Hi @Anonymous

Since card visual only show a single value,

You need to determine which total formula you need to display, then just use the single formula, like 

total=CALCULATE(SUM(DocumentItems[ExtendedCost]),RELATEDTABLE(SOP10200),DocumentItems[ItemType_All]="Product")

If you want to show different kinds of total in the card visual, you need to create a measure using a IF statement, when you select something on a slicer or another visual, the card visual would change the value along with your behaviour.

Best Regards

Maggie

[Anonymous]

Thank you for the reply.

OK, I see what you're saying, but the summed total is a single value, is there no way to simply disply the summed total of a column on another visual in a different location?

Thanks again!

[v-juanli-msft]

Hi @Anonymous

It is possible to display the total of a column in the other visual, But from your formula, it seems this is a measure, it is a litter different for the formula to calculate the total.

Best Regards

Maggie