Which function to use to perform a calculation on the sliced rows in a table?

[UsePowerBI]

Hello

When a table is filtered/sliced, only some rows are visible.

How can I calculate the total in a specific field for these only rows?

Thanks!

[az38 · Accepted solution]

@UsePowerBI 

smth like measure

CALCULATE(SUM(Table[Value]), ALLSELECTED(Table))

[Greg_Deckler]

@UsePowerBI - You generally use a measure for something like that. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.