Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |