Forum Discussion
Scratching my head with trying to transform data.
Hi timg
Appreciate you getting back to me, yes that looks like it will do the trick, however when replicated it says that my 'intensity' column which is your 'ReservationNo' in the example can't be used in that way, is it because my reservationNo equivalent is being made up by another measure?
Here is the measure, can you combine the two?
Intensity = COUNTROWS(FILTER('Desk Reservations', 'Desk Reservations'[DeskText] in VALUES('Desks'[Title])))The above is basically trying to see how many times a desk appears in DeskText
Title being a complete list of all the desks and desk reservations being rows of desks which might be the same.
Sorry, I think I'm confusing myself now!
D
ah oke so if I understand correctly you don't have the information summarized in the table but instead you have a table in which desk 1 for example occurs in 20 rows, meaning there were 20 reservations. In this case you would indeed calculate it with a measure instead of a column, which would require you to add a summarize in the calculation to get the totals for all desks. This would look something like the image below.
So you still have the DIVIDE, but instead of dividing column values you divide the COUNTROWS() measure (i simplified mine by just taking a countrows of the table) by the maxx number returned from a summarized table of countrows per desk.
Hope that helps!
Regards,
Tim