Table that shows data only for last month (unless the user want otherwise)

[Anonymous]

Hello,

I have 2 tables:
1) Table with a list of roles and employee number attached to them.

 

2) Chart with dates 

  

Every person is attached to a different date (they are taken from excel- there is a difference between specific days but it is not the case) 

Difficulty is:
I want this first graph to show on a default nr of employee only for the actual month (March in this case)

But it is summing up all the employees for all the months, unless I click particular month. 

I was thinking about adding to this visual a filter with date, but then interaction with the date graph no longer works.

Do you have any idea how to do it?

[ryan_mayu · Accepted solution]

@Anonymous 

please try to create a measure

Measure = 
VAR maxdate=max('Table'[Date])
return CALCULATE(count('Table'[First&Last]),FILTER('Table',YEAR('Table'[Date])=year(maxdate)&&MONTH('Table'[Date])=month(maxdate)))

Below is the attachment

[Anonymous]

Thanks sooo much !

[ryan_mayu]

you are welcome

[Greg_Deckler]

@Anonymous Well you could create a measure that returns 1 for only the most current month and 0 otherwise and filter on that. But if I understand your second question, you would want a way for users to disable this, correct? Perhaps you could use something like HASONEVALUE to check if the user has selected something in the date graph and if so, return 1. If a check confirms that nothing has been selected, then you could implement returning 1 for the current month only and 0 otherwise.

[Anonymous]

@Greg_Deckler 

Thanks for quick reply.

Is there no simpler way to do it?

I am not soo good at DAX