Filter card when selected and show default value when not selected

Question

Hi Experts,&nbsp;I have this data here whereas my table has these 3 columns:1. Month2. Year3. Employee Name&nbsp;I want my Card to show the distinctcount of employee name on the latest Month &amp; Year by default, and show the selected Month and Year if there is any selection.&nbsp;&nbsp;Kindly advise! Thank you!

freemanz · Answer

hi&nbsp;winniexlee&nbsp;tried with such dataset:&nbsp;it worked liked this:&nbsp;

freemanz · Answer

hi&nbsp;&nbsp;&nbsp;winniexlee&nbsp;try like:Measure =&nbsp;VAR _MaxYear = CALCULATE(MAX(TableName[Year]), ALL(TableName[Year]))VAR _MaxMonth =MAXX(&nbsp; &nbsp; FILTER(TableName,&nbsp;TableName[Year] = _MaxYear),&nbsp;&nbsp;&nbsp; &nbsp;TableName[Month])VAR _CountMax =&nbsp;CALCULATE(&nbsp;&nbsp; &nbsp;DISTINCTCOUNT(TableName[Employee Name]),&nbsp;&nbsp; &nbsp;TableName[Year] =&nbsp;_MaxYear,&nbsp;&nbsp; &nbsp;TableName[Month] =_MaxMonth&nbsp;)RETURNIF(&nbsp; &nbsp; NOT ISFILTERED(TableName[Year]) ||&nbsp;ISFILTERED(TableName[Month]),&nbsp; &nbsp;&nbsp;_CountMax,&nbsp;&nbsp; &nbsp;DISTINCTCOUNT(TableName[Employee Name]))

winniexlee · Answer

Hihi, the result is not showing correctly.

I forgotten to mention that i have a column name "Employment Type" in another table, whereas i only want to look at those that are labour supply or permanent employees. Is it possible to use Month Name instead of Month Number also?

freemanz · Answer

hi&nbsp;winniexlee&nbsp;1. you can place a slicer or filter for&nbsp;labour supply or permanent types.2.&nbsp;Month Name instead of Month Number? seems fine. Just give it a try.&nbsp;&nbsp;p.s. please consider&nbsp;@someone, if you seek further suggestions.&nbsp;

winniexlee · Answer

FreemanZ&nbsp;apologies, I already have a Slicer for Month, Year and Employment Type.&nbsp;HeadcountByDate = VAR _MaxYear = CALCULATE(MAX(TableName[Year]), ALL(TableName[Year]))VAR _MaxMonth =MAXX(&nbsp; &nbsp; FILTER(TableName&nbsp;[Year] = _MaxYear), &nbsp; &nbsp; TableName&nbsp;[Month Name])VAR _CountMax = CALCULATE(&nbsp; &nbsp; DISTINCTCOUNT(TableName&nbsp;[NAME]),&nbsp; &nbsp; TableName&nbsp;[Year] = _MaxYear,&nbsp; &nbsp; TableName&nbsp;[Month Name] =_MaxMonth,&nbsp; &nbsp; OR(TableName&nbsp;[Emp Type] = "Labour Supply",TableName&nbsp;[Emp Type] = "Perm" ))RETURNIF(&nbsp; &nbsp; NOT ISFILTERED(TableName&nbsp;[Year]) || NOT ISFILTERED(TableName&nbsp;[Month Name]),&nbsp; &nbsp; _CountMax,&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; DISTINCTCOUNT(TableName&nbsp;[NAME]),TableName&nbsp;[Emp Type] = "Labour Supply" || TableName&nbsp;[Emp Type] = "Perm" ))&nbsp;The above is working for the default value. But whenever i selected either a Year/Month/Employment Type, the number is a little bit off.

Forum Discussion

Filter card when selected and show default value when not selected

6 Replies

Related content

Slicer default selection

Selected slicer

How to set default selection to blank for single selection slicer ?

Parameter selection for charts

Function selection