topic Re: How to link 2 Dynamic Grouping with each other ? in DAX Commands and Tips

How to link 2 Dynamic Grouping with each other ?

kidpk111 — Fri, 25 Nov 2022 03:10:20 GMT

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 — Fri, 25 Nov 2022 11:14:32 GMT

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!