Forum Discussion
two different Dates count in one dashboard
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
Have a single calendar table with each date a unique value.
Create two relationships between your fact table and your calendar table:
- Calendar[Date] ---> Fact[Arrival Date] (one to many)
- 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.
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:
5 Replies
- rbriga
Impactful Individual
Have a single calendar table with each date a unique value.
Create two relationships between your fact table and your calendar table:
- Calendar[Date] ---> Fact[Arrival Date] (one to many)
- 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.
thanks that worked just fine !!
