Forum Discussion
Scratching my head with trying to transform data.
Hi all, I'm trying to get a set of data which results in a decimal place from 0 to 1 to use in a intensity heatmap. The data I have is a list of desks say 1-30 and another column where we hav...
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