Hi All,
I need your expertise to look in to the below issue.
What I need is, remove the subtotal of rows which has no headers.
Table Name is 1.Transactions
I have done the grouping of BS items in a separate table inside the power with additional 5 tables for sorting.
For. e.g. Under Assets (level 1), I have Current Asset and under current asset i have another 3 levels and so on.
Hi @shareezsaleem ,
Do you mean the row header is blank like below?
Measure = IF(NOT(ISINSCOPE('Table'[sub]))&&SELECTEDVALUE('Table'[header])=BLANK(),BLANK(),SUM('Table'[value]))
Best Regards,
Jay
Thanks for the reply.
I have 5 Levels (Row) associated with each GL
Level 1: Asset, Equity & Liability
Level 2: Current Asset, Non-Current Asset, Current Liability, Non-Current Liability etc.
Level 3:
Level 4
Level 5:
For. e.g. I have nothin after 2nd level for Equity--Equity then in level 2 Net Profit/Loss
But if I expand all levels in Power BI it showes total everywhere.
Please provide a solution (not switching off the row subtotal option)
