Forum Discussion

Mkrishna's avatar
Mkrishna
Helper III
2 years ago

Using Supporting table or other table to creating Matrix View in Power BI

Hi All,

 

I am a new to PBI. I have a sales data which consist of store number, Manufacturer, Brand, Product and Sales Revenue. I wanted to see how much of the sales revenue is by Manufacturer Dhoni and how much is my Other manufacturer. I also wanted to to see how much is by Brand Buddha, remaning brand of Manufacturer Dhoni and rest of the other brands.  I have already committed a Fact Table and done some other measures

 

For this I created a Supporting Table called ManufacturerTable  with items in column , Dhoni and Rest. Similary, I created another Supporting Table called BrandTable with items in columns, Buddha, Other product of Dhoni Brand and Rest of other products.

How can I use the supporting table and do the calculation as mentioned above and use matrix view to visualize the data. I do not have concept of doing this things. Please do guide. 

Thank you in Advance

Data Summary.

A store can sell product of different manufacturer. A manufacturer can have different brand and a brand can have different products.

 

I want to matrix visualization in the folllowing format


I do not have the idea/trick concept for doing this one. Please guide me how can I do this.