Forum Discussion
Matrix Table interaction to Table Visual
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 |
4 Replies
Hi uranus
Try with this measure
Count_Major_Overdue = CALCULATE( COUNTROWS(TableName), TableName[RiskRating] = "Major", TableName[Status] = "Overdue" )Let me know if it works.
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?
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.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
