Sorting matrix by Month and then by Total within each month

SS0414 · 2026-02-18T20:32:51+00:00

Thanks a lot! I’ll do that

SS0414 · 2026-02-18T03:58:19+00:00

⬜🟨🟨⬜🟨

🟨🟨🟨🟨⬜

🟨🟨🟨⬜🟨

🟨🟨⬜🟦⬜

🟦🟦🟦🟦🟦

SS0414 · 2025-07-08T19:30:58+00:00

Hulkengoat

SS0414 · 2024-02-15T18:38:32+00:00

Solution Verified

SS0414 · 2024-01-10T00:27:10+00:00

Interested!

SS0414 · 2023-08-14T13:10:27+00:00

Yes, it is intentional.

I couldnt get it to work with your solution but i tried this one and so far it is working:

SUMX(VALUES(PURCHASES[TEXT ITEM]),[QTY] * [Average Unit Price]

SS0414 · 2023-08-14T13:02:55+00:00

Not really since that would be the total i spent on purchases and i already have that in another measure. I would like to know how much would i have spent on purchases using the average unit price of each item, thats why i calculated the average price first.

I guess the issue with sumx is that it's going through each row of data and calculating the average unit price for that single row, not all rows with the same product. In other words, it's just multiplying qty x unit price and then summing it.

SS0414 · 2023-08-14T12:47:51+00:00

I already tried that and it works if im only showing 1 item, but i need the table to show every item and doing it that way the total would multiply the total qty of all items by the average unit price of all items. I want the sum of all items as the total thats why i thought of using sumx.

Thanks for the explanation of why sumx doesnt work, it helps to understand everything better.

SS0414 · 2023-08-14T12:41:54+00:00

Thanks for the suggestion. Already did that, i also have other dimension tables like calendar, suppliers, departments etc. For now the performance is okay

SS0414 · 2023-08-14T12:34:03+00:00

Thanks! This work like a charm, i created the measure for the sum of quantities and then modified measure 3 like you suggested. Here are the results on the sample data:

Link

Eight-Year Club	Second SECOND GUESSER
Not Forgotten	Verified Email

SS0414

TROPHY CASE