two different Dates count in one dashboard

[Hifni93]

hello Community 
i have my table withe the following columns Assetnum(identity),claasification, Arrival date(year) , Decomissioning date(year) 
what i am trying to do is to have the count of dates in one dashboard that have the year in axis thus for example for the years after 2016 i want to know the count of arrival date and the count of decomissioning date to do so i had to create another table that have the years from 2016 and on, and duplicate my table and i joined the year table to my original table and the duplicate table and i got the desired results , my problem now is that i have to filter the dashboard using the classification column wish results on filtering just one of the two dates is there anyway to do it ?  or another way to achieve the same result ?
here is my dashboard 

and here is my model 

[rbriga · Accepted solution]

Have a single calendar table with each date a unique value.

Create two relationships between your fact table and your calendar table:

1. Calendar[Date] ---> Fact[Arrival Date] (one to many)
2. Calendar[Date] ---> Fact[Decomissioning Date] (one to many) Inactive

Then you can have two measure to display on the same chart:

Rows (Arrival) = COUNTROWS('Fact Table Name')

And

Rows (Decommission) = Calculate(COUNTROWS('Fact Table Name'), USERELATIONSHIP('Calendar'[Date],'Fact Table Name'[Decommission Date]))

This should do it- you switch the relationship within the DAX measure, without a duplicate calendar table.

[Hifni93]

@rbriga taking a small look into my graph i noticed a small problem taking a look at the year 2016 the count with the small amount (886) is above the hiegher count (1803) looking at the Y axis this should be the other way is there anyway to fix this ?

thanks

[rbriga · Accepted solution]

Note that this is a stacked area chart. This is the expected behavior.

Either:

1. Change into a (non-stacked) area chart 

or 2. Switch the order of the measures in the visualization pane:

[Hifni93]

well thanks that worked just fine 

[rbriga · Accepted solution]

Have a single calendar table with each date a unique value.

Create two relationships between your fact table and your calendar table:

1. Calendar[Date] ---> Fact[Arrival Date] (one to many)
2. Calendar[Date] ---> Fact[Decomissioning Date] (one to many) Inactive

Then you can have two measure to display on the same chart:

Rows (Arrival) = COUNTROWS('Fact Table Name')

And

Rows (Decommission) = Calculate(COUNTROWS('Fact Table Name'), USERELATIONSHIP('Calendar'[Date],'Fact Table Name'[Decommission Date]))

This should do it- you switch the relationship within the DAX measure, without a duplicate calendar table.

[Hifni93]

thanks that worked just fine !!