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
Hi ING_BT ,
Has I refer the the calculation is made at brand level, if you need to redo this to have all the brands selected and all the words this can be changed.
Hello Félix,
Yes I understand, thank you!
If I may, I have another question concerning the measure:
How would you change the measure to include all the "Empty ranks" which are considered as "Not Ranked" into a "Not Ranked" interval ?
(obviously this doens't work with the <Max & >= MIN)
It's basicaly to classify everything that as the average = blank()ISBLANK(AVERAGE ( Words[Rank] ))
(PS: it's normal that I put 50 as max in the 21 to 49 formula - the data is not the cleanest)
Best,
BT
