Spending by Category for Top Spenders

BE123 — Mon, 10 Jul 2023 21:51:24 GMT

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!

Re: Spending by Category for Top Spenders

sevenhills — Tue, 11 Jul 2023 00:30:05 GMT

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!

topic Spending by Category for Top Spenders in DAX Commands and Tips

Spending by Category for Top Spenders

Re: Spending by Category for Top Spenders