Forum Discussion
Solved
Dynamic segmentation based on the growth
Hi all, I checked a lot of topics similars than the problem I have but I couldn't find any solution. I am creating a page to analyse the product performance by territory for a selected cycle. ...
Hi Konrad_Schargel ,
For this you need to add a measure to filter out the data based on the growth.
Create the following measure:
Filter Ranges = var temptable = FILTER('Table (2)', 'Table (2)'[Lower] <= [Growth % Total] && 'Table (2)'[Upper] >= [Growth % Total]) return COUNTROWS(temptable)Now add this measure into the filter of the visual, and select he is not blank option:
Hi Konrad_Schargel ,
For this you need to add a measure to filter out the data based on the growth.
Create the following measure:
Filter Ranges = var temptable = FILTER('Table (2)', 'Table (2)'[Lower] <= [Growth % Total] && 'Table (2)'[Upper] >= [Growth % Total])
return
COUNTROWS(temptable)Now add this measure into the filter of the visual, and select he is not blank option:
