topic Re: subtotals in DAX Commands and Tips

subtotals

Subhash08 — Thu, 22 Feb 2024 15:01:42 GMT

Hi all, i want to add subtotals in my dynamic P & L table like in the first snap

please help me

thank you

Re: subtotals

Greg_Deckler — Thu, 22 Feb 2024 15:21:41 GMT

Subhash08 Unforatunately that is not easy. Two methods are to use "Measures on rows" feature of a matrix and here is another way. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

Note, the article is for controlling the columns, but it's the same concept for rows.

Re: subtotals

Subhash08 — Fri, 23 Feb 2024 11:04:17 GMT

hi Greg_Deckler , i tried the way that you mentioned. but it is not worked. i have three hierarchy row wise
1. product_category
2. new_category
3. line item (income, COS, profit, profit %)

can you please tell me alternative approach for this ?

Re: subtotals

Greg_Deckler — Fri, 23 Feb 2024 11:23:51 GMT

Subhash08 That's just it, I don't know of another way to do it. If you can post sample data as text I can take a look.

Re: subtotals

Subhash08 — Fri, 23 Feb 2024 11:52:42 GMT

Greg_Deckler can you please share your mail ID, i will share the file. can you please check it?

Re: subtotals

Greg_Deckler — Fri, 23 Feb 2024 17:11:49 GMT

Subhash08 gdeckler @ gmail

Re: subtotals

Subhash08 — Sat, 24 Feb 2024 06:06:34 GMT

Greg_Deckler sent a mail sir , please check sir
my mail : business2subhash@gmail