Matrix Visual & Dynamic Table & Dynamic Measures

Question

Hi&nbsp;I am using a matrix visual to present an income statement. I would like to have the values of a chosen dimension as the columns in the matrix visual. I am struggling to pull in my measure that I created into the column part of the visual, I think due to my DAX not being correct. So I&nbsp;NEED HELP&nbsp;with DAX I think.My data:Dimensions (tables): Product, CompanyDimension values:ProductID…productname – product A, product B, product C&nbsp;CompanyID..companyname – company A, company B, company C&nbsp;Fact Table: Columns for Attribute, product(id), company (id), Amount/ValueAttribute is: Revenue, Cost of Sales etc&nbsp;&nbsp;Thus visual would look like this:if Product was selected:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Attribute&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Product A&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; Product B&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;Product&nbsp; C&nbsp; &nbsp; |&nbsp; &nbsp;Grand Total&nbsp; &nbsp;Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Cost of Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp;if Region was selected:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Attribute&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Company A&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; Company B&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;Company&nbsp; C&nbsp; &nbsp; |&nbsp; &nbsp;Grand Total&nbsp; &nbsp;Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Cost of Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp;So far, I have a Table which has one column which contains a list of all the Dimensions and sub dimensions that could be selected i.e.Product, Companies etc – see below the table&nbsp;&nbsp;&nbsp;NEED – how can I modify my IS DIMENSION to replace the Product, and Product A, B, C with the actual table eg DIM_Product and DIM_Product[Productname], DIM_Companies and DIM_Companies[Companyname] ? or can I use DAX otherwise?&nbsp;NEED – which DAX do I need as measure to pull into matrix visual to respond dynamically to the selection of IS Dimension – eg selection of product or company must have effect that product A, B, C is shown as columns?&nbsp;NEED – if I want two filter visuals (IS Dimension and IS Dimension – sub) and I want the IS Dimension – sub to respond to IS Dimension selection, which DAX do I need? i.e. I want IS Dimension sub filter visual to show product A, B, C when Product is selected on IS Dimension filter visual&nbsp;This is my actual situation at the moment:PLEASE NOTE – Gross Written Premium below is basically “Revenue” etc. these are incomes and expenses for insurance business.. and the columns as you see them there is Product A, B, C etc&nbsp;Measures I have created so far:Selected Dimension IS&nbsp;Dimension Selected IS&nbsp;&nbsp;PLEASE HELP 😊amitchandak&nbsp;

datainsights · Answer

Anonymous,&nbsp;This link discusses dynamically switching dimensions:&nbsp;https://www.thedataschool.com.au/danica-hui/switching-dimensions-in-power-bi/&nbsp;

anonymous · Answer

hi&nbsp;amitchandak&nbsp;could you possibly advise on this one, please?

Forum Discussion

Matrix Visual & Dynamic Table & Dynamic Measures

2 Replies

Related content

Dynamic measure filtering

Dynamic Filter

Dynamic RLS

Dynamic Measure developement

RLS Dynamic