Forum Discussion
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.
1 Reply
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
