Spending by Category for Top Spenders

[BE123]

Hi, 

I'm trying to create a measure that I can use on a table visual to display spending by category using only data from members who have spent above a certain total amount in the filtered time range.  

The data table looks similar to this:

 

I am looking to only include values from members who have spent above $4000 total across all categories.

I used the following measure to find the total spent by these high-spending customers, but I really cannot figure out how to write a measure that will allow me to break it down by category.  

HCCTotalPaid =

var table1 = SUMMARIZE('ExampleTable','ExampleTable'[Customer], "SumPaid", SUM('ExampleTable'[PaidAmt]))

return SUMX(FILTER(table1, [SumPaid] >= 4000), [SumPaid])

Any advice would be appreciated.  Thank you!

[sevenhills · Accepted solution]

It is not clear what is the output you are expecting.

Try this:

a) Add the measure:

Category Total = 
var summaryTable = Filter(SUMMARIZE('Table','Table'[Category], "sumamt", CALCULATE( SUM('Table'[PaidAmt]))), [sumamt] >= 4000 )

var c = COUNTROWS(summaryTable) -- Testing! ... RETURN C

return CALCULATE( sum('Table'[PaidAmt]), summaryTable)

b) Drag a table visual

       Add Category, measure "Category Total" and Sum of "PaidAmt" and check the output match your requirements.

If yes, then tune to your requirements. (like formatting the measure, building the rest)

If no, copy the data to excel, and paste again here, and the output you are expecting.

This helps to test!