Good Afternoon:
I need help with my Dashboard.
I am working with a table that has the following columns:
ID
AdmissionDate
DischargeDate
RegistryDate
I created a dashboard that has a relative date slicer based on the "AdmissionDate" so that the users may select to view the different visualizations. I also have cards that will show information regarding Discharged Patients (this card is filtered by DischargeDate = Today) and also have a card to show Registered Patients (this card is filtered by RegistryDate = Today). I would like that if a user selects a date range in the slicer these two cards change based on this date but filtering the date with the appropriate field.
Example:
The slicer is set to 03/23/2020 to 03/28/2020 based on admission date. I would like that my cards show count for discharged patients during this same period.
I was reading about DAX and the SELECTEDVALUE formula. Please advice
Thanks
Mariena
Hi Mariena,
Welcome to the forum!
You haven't provided enough information, but presumably you have a date dimension table and the Slicer is using the date field from the date dimension table, as is recommended? The date field in the date table will have one active relationship to the fact table, say the AdmissionDate, and two inactive relationships to the DischargeDate and RegistryDate.
In which case you'd need to use USERELATIONSHIP to activate the inactive relationship between the Date table and the inactive RegistryDate field.
See example file attached.
Mynda
Hello Mynda!!!!
Thanks so much, you are a life saver. I spend hours trying to solve this problem, finally worked.
I love your course, it has been very helpful for my job.
Thanks so much.
Mariena
Great to know that did the job and that you're benefiting from the course 🙂 Don't be put off trying to figure things out for yourself though. Often we learn the most that way and it'll give you confidence to try things yourself.
