Forum Discussion
Is this Dynamic Value segmentation?
- 4 years ago
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
I think the Table 2 is the one I am looking for.
As, if for the selected period (with several dates), a brand has no rank at all on 10 keywords; I need to display these 10 keywords inside that +50 Not Ranked interval.
However, if there is a keyword where it has as rank but only on a few dates, it should be counted in the average, example:
Label is in the interval (2+2+10)/3=4.6 => 4 to 10
(empty are (null) and not "0" in the data, which simplyfies things?)
| 10/12 | Label | (null) |
| 16/12 | Label | 2 |
| 21/12 | Label | 10 |
| 27/12 | Label | 2 |
| 31/12 | Label | (null) |
(appologiesfor the late answer)
Thank you!
Sorry for the additional question but on this case of label will label show up in the no label words or since it was counted in the rank it wont count again?