Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Hi @Bjones-MHL
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
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!
Hi @Bjones-MHL
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |