Forum Discussion
Is this Dynamic Value segmentation?
Hi ING_BT ,
Based on the description you have you need to do a measure similar to this one:
Count Words on ranking = VAR temptable = SUMMARIZE ( words, Words[Brand], Words[Keyword], "AVerageRanking", AVERAGE ( Words[Rank] ) ) RETURN COUNTROWS ( FILTER ( temptable, [AVerageRanking] <= MAX ( Ranking[End] ) && [AVerageRanking] >= MIN ( Ranking[Start] ) ) )I have added some words counts on the Brand A and has you can see the total word count is 2 always:
Be aware that this calculation is at a brand level if your try to do it with all brands at all ranking the calculation is incorrect has you can see in the Total column below
Hi ING_BT ,
Based on the description you have you need to do a measure similar to this one:
Count Words on ranking =
VAR temptable =
SUMMARIZE (
words,
Words[Brand],
Words[Keyword],
"AVerageRanking", AVERAGE ( Words[Rank] )
)
RETURN
COUNTROWS (
FILTER (
temptable,
[AVerageRanking] <= MAX ( Ranking[End] )
&& [AVerageRanking] >= MIN ( Ranking[Start] )
)
)
I have added some words counts on the Brand A and has you can see the total word count is 2 always:
Be aware that this calculation is at a brand level if your try to do it with all brands at all ranking the calculation is incorrect has you can see in the Total column below
Hello Félix,
Thank you so much for your help! Your solution is very clear and It works perfectly. And thank you for very detailed explanation.
I spend hours to solution this, you cannot imagine the relief! I understand the logic now (thank you for naming it "temptable", makes it so obvious now!)
All the best,
BT