Thanks for reply.
No problem, link as follows.
I've made this version by removing the data sensitive material. The premise is still the same. The City Rev and BoS City tabs are fine. It's the Adult/Child tab where I'm unable to complete. The measure values currently show the total number of records, whereas I need to replace this with the calculated field I mention previously.
Essentially I'm looking to divide the number of instances of "Adult" within PassengerCategory by the number of instances of "Child" in the same measure.
Can this be done?
Thank you Eoghan
Something like this?
[Adult / Child]
sum(if [Passenger Category]="ADULT" then [Number of Records] end)
sum(if [Passenger Category]="CHILD" then [Number of Records] end)
Truncated DW_SM_10.1.twbx 89.9 KB
Thanks so much, that's exactly what I was looking for. Thanks for taking the time out to help me.
You are very welcome!