Grouping in calculated column

DAX DAX Calculations
6

Hi @Thimios,

Good to read you’ve found the Dynamic Grouping via Supporting table and Measures session. I also highly recommend examening the post by @Greg on Dynamic Grouping here.

There’s an easier way to calculate that, give this a go.

Dynamic Group count = 
VAR vTable =
    ADDCOLUMNS(
        VALUES ( Sales[Order#] ),
        "@Group", [Dynamic Grouping]
    )
RETURN

COUNTROWS( 
    FILTER( vTable,
        [@Group] IN VALUES( 'Order Value Groups'[Value Group] )
    )
)

I hope this is helpful.

1 Like