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.
Hi everyone,
Due to the nature of my report, I need to use direct query.
I found out that there is limitations especially when it comes to DAX formula. I am trying to build up something using the calculate function but it won't work.
This is the formula I am trying to write:
Current Staff =
CALCULATE( COUNTROWS( 'Staff Population' ),
FILTER( VALUES( 'Staff Population'[Start Date] ), 'Staff Population'[Start Date] <= MAX( Dates[Date] ) ),
FILTER( VALUES( 'Staff Population'[End Date] ), OR( 'Staff Population'[End Date] >= MIN( Dates[Date] ), ISBLANK( 'Staff Population'[End Date] ) ) ) )
Any ideas on how I could go around this?
Thanks in advance.
Solved! Go to Solution.
Hi @corange ,
I create an example. Is this what you want?
Current Staff 2 =
CALCULATE (
COUNTROWS ( StaffPopulation ),
FILTER (
StaffPopulation,
StaffPopulation[EndDate] = BLANK ()
&& StaffPopulation[StartDate] <= MAX ( Dates[Date] )
)
)
If not, please give me more details without sensitive information.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @corange ,
I create an example. Is this what you want?
Current Staff 2 =
CALCULATE (
COUNTROWS ( StaffPopulation ),
FILTER (
StaffPopulation,
StaffPopulation[EndDate] = BLANK ()
&& StaffPopulation[StartDate] <= MAX ( Dates[Date] )
)
)
If not, please give me more details without sensitive information.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for your help on this one!! It did work for me.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |