Matrix Table interaction to Table Visual

[uranus]

Hi Guys,

Need help, new in power bi here, I have a matrix table that contains the number of overdue items and their risk ratings. The idea is if i click on the 2 items listed under account 2 with risk rating major, the other table that i have will show specifically the 2 items only. Not all data under account 2 (which is 57). The table that i have shows all 57 items. Is this really how it works?

I tried below approaches:

1. use dax calculate(distinctcount(items), risk rating(major) && status(overdue) and use matrix table

rows = accounts

values = dax

2. created columns for each risk rating marking the overdue as 1 and 0 if not overdue and then created a table 

row=accounts

values= the three columns 

the two approaches resulted on below same visual.

	Critical	Major	Moderate
Account 1	0	0	0
Account 2	0	2	55
Account 3	0	83	45
Account 4	0	72	3
Account 5	0	12	2
Account 6	5	21	0
Account 7	0	0	87
Account 8	0	11	43
Account 9	0	1	69
Account 10	0	0	1
Account 11	0	0	5

[uranus]

Hi @Anonymous ,

Thanks for the feedback. We still need to consider if its overdue or not overdue. What i need is to see the overdue items per risk ratings. Below is the table visual i need.

Accounts	Total #	Critical Overdue	Major Overdue	Moderate Overdue
Account 1	25	1	2	3
Account 2	29	1	5	4
Account 3	38	2	6	7
Account 4	44	1	3	5
Account 5	50	9	8	1
Account 6	59	2	1	18

[Anonymous]

Hi @uranus ,

I'm not sure if I understood your requirement correctly. Could you please check if this is the result you want?
Original visual object:

After clicking:

Here is my sample data:

I didn't use any DAX, just put fields of the table into the visual:

If I understand something wrong, please forgive me and explain in more detail what you want to achieve. It would be best if you can attach your test data and expected results so that we can understand the requirements. Thank you.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[uranus]

Hi Supernababu8,

Thank you for the feedback!

I tried the countrows. Unfortunately it doesnt work as well :(. Is this maybe because its a dax measure and it only reflects the details in account level?

[suparnababu8]

Hi @uranus 

Try with this measure 

Count_Major_Overdue =
CALCULATE(
    COUNTROWS(TableName),
    TableName[RiskRating] = "Major",
    TableName[Status] = "Overdue"
)

Let me know if it works.