Hi all, I wonder if anyone can assist with my issue.
I’m using a fact table with a row for each person and multiple date columns - date registered, date booked, date of appointment, etc, with the person’s demographics such as age.
I also have a dimension table with the census population for each age.
I want to create a table visual with ‘age’ in rows, and number of people for each stage in columns (i.e count of registration dates, count of booking dates, count of appointment dates). I also want a column to show the census population for each age. The table must have a date filter.
In order that the date filter affects the date columns independently, I used role-playing dimensions. I created a date table with one active and multiple inactive relationships to each date column in the fact table, and created measures to count the number of dates with ‘use relationship’.
How would I include the census count by each age in the same table visual? It works fine if I just count the number of dates directly from the columns in the fact table, and relate the fact table (age) to the census table. But if I use the above measures, the census count doesn’t work in the table visual (it gives the same result in every row).
