How to link 2 Dynamic Grouping with each other ?

[kidpk111]

Currently, I have been successful in creating 1 dynamic group that counts total in the category like this:

By using this procedure from Enterprise DNA: https://blog.enterprisedna.co/power-bi-dynamic-grouping-banding-using-dax/
And I also create another Dynamic Grouping Measure which is the Risk level like this:

My goal is to link these 2 dynamic group to each other to get the actual value base on criteria from both of them like this:

Thank you in advance for your solution

[NikhilChenna · Accepted solution]

Hi @kidpk111 ,

This can be achieved by the below solution,

1. You can create a index column in both the Actual tables (Risk and Asset ) using the Power Query Editor.

2. After that you can create calculated column(lookup value) in the Asset Actual table, lookup the Risk column tables based on the index.

This will resolve the issue.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!