Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the below DAX Expressions
Count Of Overlaps =
var fromDate = MIN('VF Trade Spend'[From])
var toDate = MAX('VF Trade Spend'[To])
return CALCULATE(DISTINCTCOUNT('VF Trade Spend'[Contract Line #]),
REMOVEFILTERS('VF Trade Spend'[Contract Line #], 'VF Trade Spend'[From], 'VF Trade Spend'[To]),
FILTER('VF Trade Spend',
'VF Trade Spend'[From] >= fromDate
&& 'VF Trade Spend'[From] <= toDate
&& 'VF Trade Spend'[To] >= fromDate
&& 'VF Trade Spend'[To] <= toDate
)
)
This DAX measure is working, but it is really slow (takes 30+ seconds to complete).
The main point of what it is trying to do is we have a table that has a contract # and start and end dates on it. I'm trying to find a count of any contracts that have overlapping date ranges in them.
Solved! Go to Solution.
That is an optimization problem, I had the same problem and Marco Russo from SQLBI suggested to use this construct:
SUMX( DISTINCT ( 'VF Trade Spend'[Contract Line #] ), 1 )
Please read this article here. SQLBI: Analyzing the performance of DISTINCTCOUNT
That is an optimization problem, I had the same problem and Marco Russo from SQLBI suggested to use this construct:
SUMX( DISTINCT ( 'VF Trade Spend'[Contract Line #] ), 1 )
Please read this article here. SQLBI: Analyzing the performance of DISTINCTCOUNT
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
55 | |
28 | |
18 | |
13 |