Dynamic Grouping

[Greg]

Related Content:

Below are a few examples of issues related to the Dynamic Grouping DAX Pattern from the eDNA resources.

Enterprise DNA Forum (Search):

https://forum.enterprisedna.co/t/dynamically-group-customers-by-ranking/3327

https://forum.enterprisedna.co/t/dynamic-grouping-via-support-tables/3326

https://forum.enterprisedna.co/t/combining-dynamic-grouping-with-additional-ranking-logic-with-dax/590

How To Calculate Number Of Completed Courses Per Student - Dynamic Grouping In Power BI using DAX

Ok please see below and I’ll place a link to the model This is the output [image] These are all the formula you need Unique Students = COUNTROWS( VALUES( 'Registration Data'[Student ID] ) ) Unique Registrations = COUNTROWS( 'Registration Data' ) [image] Now to get the table you need to use some advanced logic. This is exactly the same as the dynamic grouping technique explained here Need to create a table like this (doesn’t have to be exact, but close enough) [image] Then use a form…

Enterprise DNA Forum (EDNA):

Dynamic Grouping via Support Tables

Dynamic Grouping with Ranking is duplicating Customers

Context is the key here. Are you totally understand what the top 10 is at each different context (or result) in the table? That is the key to understanding the behaviour here. When you place the quarterly context in the matrix you are now working out the top 10 in each different quarter, not the overall top 10 from the beginning of time. The way to work these out is to break the formula down. When looking just at the ranking you’ll see it shows a greater spread of ranks for customers [imag…

Dynamic Bin Segmentation

Check out this idea here You will see with this formula that you can create virtual table by bring in difference values (ie. what if parameters) [image] I’ve just mocked this up with the table creation feature. The idea is that you would place this inside the segmentation formula Like this Customer Sales by Group = VAR CreatedTable = UNION( ROW( "List", "Bottom", "Low", [What If 1], "High", [What If 2] ), ROW( "List", "Top", "Low", [What If 3], "High", [What If 4] ) ) RETURN CA…

Enterprise DNA TV (YouTube):

Grouping & Segmenting Your Data With DAX Measure Logic - Advanced DAX

Grouping & Segmenting Your Data With DAX Measure Logic - Advanced DAX

Create Custom Dynamic Groups In Power BI - Advanced DAX

Create Custom Dynamic Groups In Power BI - Advanced DAX

How To Create Virtual Groups & New Dimensions Fast in Power BI

How To Create Virtual Groups & New Dimensions Fast in Power BI

Segment Data Based On Percentage Groups - Advanced DAX In Power BI

Segment Data Based On Percentage Groups - Advanced DAX In Power BI

Detailed Banding & Segmenting Example in Power BI using DAX

Detailed Banding & Segmenting Example in Power BI using DAX