Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Measure with default calculation

We have a table where we aggregate the total no of staffs per month and I have created the measure as below.


Total Employee = Sum(StaffCount)


However, when the measure is selected , it shows a value of 2m+ statffcount which is the total staff records in that table. The current month 202002 has a staff count of 25k and I want the measure to show this number by default. i.e =calculate(Sum(StaffCount), (FILTER('Date','Date'[CurrentMonth] = "yes"))


However, when the end user brings in the month dimension, I want it to default to Sum(StaffCount) so they can see the staff movement over time.


I am thinking along the line of


If value from the date [date].[datekey] dimension is detected, Sum(StaffCount) else calculate(Sum(StaffCount), (FILTER('Date','Date'[CurrentMonth] = "yes"))


Please advise.






Super User IV
Super User IV

Re: Measure with default calculation

Well, you would have to write your measure to essentially have an IF statement in it that would check your date dimension. More or less impossible to be more detailed with the level of information provided. Please see this post regarding How to Get Your Question Answered Quickly:


Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.