Forum Discussion
Clustered column chart - Combined Chart
If I got it correctly. You need to create a common Date dimension and join both dates with it. One active and one Inactive. And then use userelation to activate the other.
Refer to My blog that will help you : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Hi Erikestrela ,
If I understood how total open and total closed calculated correctly, you can create a Date table first and then create the following measures:
Total open =
VAR _date =
SELECTEDVALUE ( 'Date'[Date] )
RETURN
CALCULATE (
DISTINCTCOUNT ( 'Table'[Incident Number] ),
FILTER (
ALLSELECTED ( 'Table' ),
_date >= 'Table'[Date Recorded]
&& _date <= 'Table'[Date Closed]
)
)Total Closed =
VAR _date =
SELECTEDVALUE ( 'Date'[Date] )
RETURN
CALCULATE (
DISTINCTCOUNT ( 'Table'[Incident Number] ),
FILTER (
ALLSELECTED ( 'Table' ),
_date < 'Table'[Date Recorded]
|| _date > 'Table'[Date Closed]
)
)Here is the demo based on my understanding, please try it:
If my understanding has something wrong, please let me know and you can share more details like how they calculate for further discussion.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-yingil!
With your example I could have more insights of how to deal with it.