Choose measure against baseline

[davidepolizzi]

Hello community, 

I have a visualization as a table. I have several headoucounts (one row per employee and each row has a date field). 

I want to show the headcount by group (one of the field in the dataset) and count the primary key to get the different headcount per group per period. 

Now comes the tricky part I can't figure out. 

I have a pre-set baselie, and I would like the user to select the period they want to compare against the deadline. 

I can acheve this by adding a filter and select two period (baseline+period to compare). but ideally I would like the user the be able to only choose the comparing period and not the baseline.

I would like to, basically have a filter (force single value selection (easy)) but have a value (the baseline) unaffected by the filter selection.

Is this at all possible? How would I go about it?

Thanks in advance to any pointer. I don't need full solution, but if anyone could point me in the right direction....I am quite new to Power BI.

[v-jayw-msft · Accepted solution]

Hi @davidepolizzi ,

You can try creating a CALENDAR table and using the date field as slicer then creating a measure like below.

calculate(count(id),filter(table,table[date]=selectedvalue(CALENDAR[date])))

This would help calculate the headcount by the selected date and the baseline in data table won't be filtered by the slicer.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.