Forum Discussion
Regrouping/binning ranged data
Super Usermaxdtraff , are this calculations in first table in power bi or came from DB.
Looking at table 2, it looks like a set of new measures
like
new speed1 = calculate(max(Table[speed1]), all(Table))
new speed2 = calculate(max(Table[speed2]), all(Table))
These aren't calculations in the first table, they are the boundaries for the speeds that the CountOfSpeed(0-8) will calculate and come directly from the server. I am afraid I am explaining badly as I have given myself a headache trying to sort this today!.
Every vehicle travelling below the speeds given in the Columns labelled Speed0-8 will be counted in the corresponding CountOfSpeed(0-8). So if 3 cars pass Location 1 travelling at 30mph (falling into catgory Speed1) they will appear in CountOfSpeed1 as a value 3. I need for the CountOfSpeed calculation to group the counts when they fall into speed bins that are below 40mph into CountOfSpeed0. If that makes sense?