using power BI need to generate table format with calculations and column values show as row heading

Rathna — Thu, 13 Oct 2022 06:25:04 GMT

sample data

BU	severity	status open/closed	Host name	DNS name	comments	status
BUnit1	Critical	Open	hostnameIN1	DNSname1	Informational	Open
BUnit1	High	Closed	hostnameIN2	DNSname2
BUnit1	Medium	Open	hostnameIN3	DNSname3
BUnit1	Low	Closed	hostnameIN4	DNSname4
BUnit1	Low	Open	hostnameIN5	DNSname5
BUnit1	Medium	Closed	hostnameIN6	DNSname6
BUnit1	High	Open	hostnameIN7	DNSname7	Informational	closed
BUnit1	Critical	Closed	hostnameIN8	DNSname8
BUnit2	Critical	Open	hostnameIN9	DNSname9
BUnit2	High	Closed	hostnameIN10	DNSname10
BUnit2	Medium	Open	hostnameIN11	DNSname11
BUnit2	Low	Closed	hostnameIN12	DNSname12
BUnit2	Low	Open	hostnameIN13	DNSname13
BUnit2	Medium	Closed	hostnameIN14	DNSname14	Informational	open
BUnit2	High	Open	hostnameIN15	DNSname15
BUnit2	Critical	Closed	hostnameIN16	DNSname16
BUnit3	Critical	Open	hostnameIN17	DNSname17
BUnit3	High	Closed	hostnameIN18	DNSname18
BUnit3	Medium	Open	hostnameIN19	DNSname19
BUnit3	Low	Closed	hostnameIN20	DNSname20
BUnit3	Low	Open	hostnameIN21	DNSname21	Informational	closed
BUnit3	Medium	Closed	hostnameIN22	DNSname22
BUnit3	High	Open	hostnameIN23	DNSname23
BUnit3	Critical	Closed	hostnameIN24	DNSname24
BUnit4	Critical	Open	hostnameIN25	DNSname25
BUnit4	High	Closed	hostnameIN26	DNSname26
BUnit4	Medium	Open	hostnameIN27	DNSname27	Informational	Open
BUnit4	Low	Closed	hostnameIN28	DNSname28
BUnit4	Low	Open	hostnameIN29	DNSname29
BUnit4	Medium	Closed	hostnameIN30	DNSname30
BUnit4	High	Open	hostnameIN31	DNSname31
BUnit4	Critical	Closed	hostnameIN32	DNSname32

power BI report

Rathna Tracker