Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I have a formula that seems to work (assigns negative deltas to negatives, positive deltas to positives), but I can't really understand it, thus not sure if it's possible to improve it.
My_Measure =
CALCULATE (
[Delta],
FILTER (
VALUES ( Products[Items] ),
COUNTROWS (
FILTER ( Ranges, [Delta] >= Ranges[Negative] && [Delta] < Ranges[Positive] )
) > 0
)
)
Ranges is a simple table like this:
Range | Negative | Positive |
Negative | -999999999 | 0.00001 |
Positive | -0.00001 | 999999999 |
Not sure if this table is necessary, however this not my setup, so I don't want to break it, if I'm not sure 100%.
Use DAX Studio (install it if you don't have it) and check the performance of that measure in various scenarios of your dataset. That will show you if you have to optimize it or not.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
9 |
User | Count |
---|---|
28 | |
23 | |
12 | |
11 | |
10 |