drilling down \ filtering \ navigating from matix cell

[JuliaOnStock]

Hi, I am just getting started with Power BI

1.My data source is SQL server ,and I am free to design it the way I want

2.The DB contain information about products

3.I need to display something like the following matrix 

Type Quantity Income Cost

A          10          1000     500

B           20         2000      500

C           30         3000      100

ALL       60         6000     1100

The martix display information about products , as you can see I have 10 product of type A in the Quantity (can be a single table for each categroy : quantityTable  ,incomeTable ,costTable  or one table for all )

Upon clicking 10 , I need to to go to a products report page and display 10 products of Type A from Quantity

Upon clicking Quantity I need  to to go to a products report page and display 60 (All) products from Table Quantity

Thanks in advance

[JuliaOnStock]

Hi, I am just getting started with Power BI

1.My data source is SQL server ,and I am free to design it the way I want

2.The DB contain information about products

3.I need to display something like the following matrix 

Type Quantity Income Cost

A          10          1000     500

B           20         2000      500

C           30         3000      100

ALL       60         6000     1100

The martix display information about products , as you can see I have 10 product of type A in the Quantity (can be a single table for each categroy : quantityTable  ,incomeTable ,costTable  or one table for all )

Upon clicking 10 , I need to to go to a products report page and display 10 products of Type A from Quantity

Upon clicking Quantity I need  to to go to a products report page and display 60 (All) products from Table Quantity

Thanks in advance

[v-danhe-msft · Accepted solution]

Hi @JuliaOnStock,

Based on my test, you could refer to below steps:

Sample data:

Create a measure and create a matrix visual in page one

Measure:

Quantity = COUNT(Table2[Type])

Create a tabel in page 2 and add the [Type] column to the 'DRILLTHROUGH' filter.

Now you could get the correct result.

Before click:

After click:

You could download the pbix file to have a view:

https://www.dropbox.com/s/lvf41r8sq4mpzs8/drilling%20down%20%20filtering%20%20navigating%20from%20ma...

Regards,

Daniel He

[JuliaOnStock]

Thanks! it is working