Measure with default calculation

Anonymous — Thu, 27 Feb 2020 15:01:31 GMT

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.

Re: Measure with default calculation

Greg_Deckler — Thu, 27 Feb 2020 14:38:15 GMT

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: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

topic Measure with default calculation in Developer

Measure with default calculation

Re: Measure with default calculation