Table Visuals Concatenate

[Maximous89]

Hello power bi supporters,

i have a kind of dilama here and i need your opinions, this is the senario:

i have big table, i put it in table visual to be pivoted, i know i want to do this:

Level	Product	Value
H1	Owio1	100
H1	Owio2	200
H1	Owio3	300
H2	Poio1	100
H2	Poio3	200
H2	Poio3	300
H2	Poio4	400
H2	Poio5	500

i have slicer in the page when i choose Level H1

the table will be like that:

Level	Product	Value
H1	Owio1	100
H1	Owio2	200
H1	Owio3	300
Total		600

when i choose Level H2

the table will be 

Level	Product	Value
H2	Poio1	100
H2	Poio3	200
H2	Poio3	300
H2	Poio4	400
H2	Poio5	500
Total		1500

so far so fine,

but i know H1 Level always will be less, so i want when i choose Level H1 on slicer:

the table will be :

Level	Product	Value
H1	Owio1	100
H1	Owio2	200
H1	Owio3	300
Diff	Diff	900
Total		1500

so Diff here is total H2 - Total H1

is there away to do this please?!

[rajendraongole1]

Hi @Maximous89  - Please find the attached pbix.

Logic and virtual table created as per the above scenerio. please find it.

Hope this helps.

[Maximous89]

this is good thanks for helping but i want the result table to exactly like this,

Level	Product	Value
H1	Owio1	100
H1	Owio2	200
H1	Owio3	300
Diff	Diff	900
Total		1500

[v-hjannapu]

Hi @Maximous89,

Thank you  for reaching out to the Microsoft fabric community forum.

I would also take a moment to thank @rajendraongole1 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

As per your requirement I am getting the required solution, but it is coming in a separate column as  a different value.

Please find the attached screenshot and Pbix for your reference.
Hope this helps if you have any queries we are  happy to assist you further.

Best regards,
Community Support Team.