Make a Table with more than 1 rows

[Anonymous]

Hi All,

Need help urgently. 

I need to a make a table in power BI as follows:

	Prog1	Prog2	Prog3
For	10	20	30
Act	5	4	16
Diff	5	16	14

But when I take Matirx view. and add For,Act , Diff it is giving as drilldown view. But not in same table.

Also I tried doing it using table. but no output.

Is there any way out.

[MFelix]

Hi @Anonymous,

Check this post:

https://community.powerbi.com/t5/Desktop/Measure-in-rows-in-Matrix-Preview/m-p/143842#M62053

And go to the one refer in it that as a similçar answer you need.

http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

The attach PBIX file as an example I made for a similar request.

Regards,

MFelix

[Anonymous]

Hi Felix,

Thanks for the reply. 

But my columns "For"and "Act" are unpivoted columns and therefore are summarized. These are not measures.

So they are not allowing me to use selectedmeasure formula.

Can we try some other formula here.

And 3rd row Diff is difference between "For"  & "Act". which should be calculated.

And i need a 4th calculated row to find % for diff.

Is this possible?

[MFelix]

Hi @Anonymous,

The  Selected measure is not based on measures is a way of selecting wich columns you want on the calculations, so if you have a forecast column you will have a measure that makes the sum of that column.

I will try and make an example based on your data.

Regards,

MFelix