Forum Discussion
multiple dates on axis
Good to hear,
TABLES
_Calendar[Date] joins to Created Date and Closed Date
MEASURES
CasesOpened = CALCULATE(COUNTROWS('Cases'),USERELATIONSHIP('Cases'[Created Date],_Calendar[Date]))
CasesClosed = CALCULATE(COUNTROWS('Cases'),USERELATIONSHIP('Cases'[Closed Date],_Calendar[Date]))VISUALS
Hello,
can you share your data souces and relationships? what you posted doesn't work for me.
My Date table, date formated as date
case table, create date and close date are formatted as date
My relationships wont work, when i try to join them
Also i dont know why my x axis wont show the date on the x axis as well
This error is telling you that there is a relationship from another table that will affect the new relationships you have created.
If you can send me a screen shot of the entire data model relationship view we can try and work it out. Alternatively the measures that I have provided will work even if the relationships are set as inactive (dotted line).
Hello,
Attached is the entire data model
There is a bit going on here, Looking at your model you can set the relationships that I gave you as inactive and the measures will still work as they are calling the USERELATIONSHIP() function.
Hi saunders,
I turned off the relationships and it seems to be working a little better, previously it wouldnt show any of the dates on the bottom. I also wanted to ask if we are using the same visualizations chart as well.
What is this?
The measures that I gave you should be here.
I tried doing what you did but it would give me this error (after I turned off the relationship ) So i just switched it to count of close/create dates
what it would give me if i turned on the relationship
When you say "turned off" the relationship what do you mean? have you removed the relationship (no line) or made it inactive (dotted line)?
Yes these are the same visual.
Yes i have turned it off.
After looking at my data I know what my issue is. 'Case id' on my 'cases' table can be duplicated. Is there a way to have the distinct count of a case id for both 'close date' and 'create date' based on the calendar date? I want to do it this way so I have the calendar date as a single filter for both of it.