Measure that sums a value based on whats been filtered in a table

[akhaliq7]

Is there a measure I can create that will return the sum of sales in my card based on what is left in my table.

For example in my page I have a card visual and a table visual. I place a sum(sales) measure in my card and place fields in my table from my fact table. I then filter my fact table from the filter panel (not a slicer) is there a way if I filter my table only shows from 100 rows to 10 and the sales go from 100,000 to 10,000 is there a way for it to update in my card. I don't want to use a page level fiter I want to continue using visual level filters as it is more accurate in my case.

[v-yalanwu-msft · Accepted solution]

Hi, @akhaliq7 ;

It's Okey, I tested it as follow:

sum = SUM('Table'[value])

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.