First, thanks a speedy response. This problem is a bit urgent actually. Problem one, the tables are in Hebrew. But here is the summary. It’s all about Corona virus for a specific town. I’m producing a daily dashboard based on stats from the government.
2 fact tables… people who are ill and fact table 2 those who are in isolation.
I added a date table and created 1 main relationship between the date table and the date people were added to the list (for each table).
I then create inactive relationships and use USERELATIONSHIP for some of the measure. As I said, the measures work OK on their own, but not with a date slicer.
count of people in isolation, out of isolation, cumulative totals and daily totals for both
count of people with the virus, in hospital, left hospital - cumulative and daily totals
I have lots of dates that I use for these measures but as I said, none of them work with a date slicer, so I can’t get history dynamically. I only have the current status on the dashboard.
I can send you the .pbix but you won’t be able to read it! Grrh.
people in isolation = calcuate([total count of patient ids],filter(isolation[isolation[end isolation date]>=today())
CALCULATE([total in isolation]-[left isolation], DATESYTD(‘Date’[Date]))
Does any of this make sense? I’m in a pickle as you can see!