Hi everyone, I need your help in calculating the calculation shown by Sam in the latest YouTube video - Dynamic Segmentation With Dynamic Parameters https://youtu.be/EAbCHqMRE5Y. I have a similar calculation by using RANKX
reg Customer per regionTop 20 = CALCULATE( [Total reg. Customer per regions]; FILTER( VALUES( Regions[Postcode] ); RANKX( ALL( Regions[Postcode] ); [Total Sales]; ; DESC ) <= [Selected Metric Top 20] ) )
and the total value is not calculated correctly.https://youtu.be/Rii_6qkLNh8. Does anyone have an idea? For example from Dynamic Segmentation With Dynamic Parameters.