ADD Custom Rows in Table Matrix

[unais]

Team,

In a Matrix, I have Sales Income, Material Cost, Cost of Sales  etc groping from the Table value

As mentioned first Screenshots need to ADD new Custom rows in Matrix BI Report. how can we add custom

[v-kelly-msft]

Hi @unais ，

Go to query editor>add column>custom column,then use below formula:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[unais]

Hi,

thanks your replay but am looking to ADD new Rows in " MATRIX " Visual , I need to custom rows in between two Rows in MATRIX Visuals

[unais]

i have a visual Matrix ,First column is "GL Account Group " like , Sales income, Cost, Salaries and  Second columns is Total amount by accounts groups accounts.

As below

Sales income      20000

Cost of Sales      1000

salaries               30000

other expense     200

transport Expe     500

now I need a new Row between below Salaries with Some Mesure Values..

[amitchandak]

@unais ,You might have to create an intermediate Table

New table

Union (
Summarize(Table,Table[Calegory],"Value",Sum(Table[value)),
Summarize(Table,"Calegory","Total","Value",Sum(Table[value))
)

[unais]

@AM  can you please elaborate process

[v-kelly-msft]

Hi @unais ，

I have a workaround for you :

1.I create a sample table as below:

2.Create a dim table using below dax expression：

Table 2 = UNION(DISTINCT('Table'[Column1]),ROW("Column1","Total"))

3,Then create a relationship between the 2 tables;

4.Create a measure as below:

Measure = IF(SELECTEDVALUE('Table 2'[Column1]) in FILTERS('Table'[Column1]),MAX('Table'[Column2]),SUMX(ALL('Table'),'Table'[Column2]))

And you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[unais]

@v-kelly-msft   thanks for you support..

refer below file, I had created Two table, 

Transaction table is about all transaction

matrixoder Table which exactly we need in Matrix visual

In Matrixorder Table row (4 and 5) don't have a relation with the Transaction Table but in Matrix Visual Need show Value

Gross profit: a total of "Sales +Sales cost +Salaries"

Gross Margin: Margin between "Sales " and Cost (Sales cost +Salaries)

https://1drv.ms/u/s!AnNpoBzguZmmgeVBArkjvyPR0NIYTQ?e=SvxH3N

[unais]

Team

any hope

[unais]

reffer below link... Exact Solution....

https://1drv.ms/u/s!AnNpoBzguZmmgeVObN4IPUbCN1jEzQ?e=fgxosj

[unais]

I had created a new Mesure which I need to Add on below of Total as Rows. Mesures are not able to ADD has Row in Matrix Visual.

[unais]

am look like to have, below Exact solution, based on the below link its not clear solution.. any one have detailes

https://blog.enterprisedna.co/power-bi-reporting-templates-expanded-power-bi-visualization-concepts/

[amitchandak]

@unais 

If the are measures
Total = [Sales Income]+ [Material Cost] + [Gorss Profit] // Same way Add others
If they are dimesnion values
Total = calculate(sum(Table[Values]), Table[Type] in {"Sales Income","Material Cost","Gorss Profit"}) // Same way Add others

[unais]

sales income, material cost ,Salaries are from Table Firleds  .. my concern is how to add this new custom rows in between the rows..