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,
Hi I'm trying to build a measure that would sum all variations over or equal to 1M and under 10M or over -10M and under or equal to -1M.
In other words:
I've tried the following but it is not working:
Weekly Delta:=CALCULATE(sum('Table'[DeltaHebdoCAD]))
Weekly1M:=CALCULATE([Weekly Delta], FILTER('Table','Table'[DeltaHebdoCAD]<10000000 && 'Table'[DeltaHebdoCAD]>=1000000), FILTER('Table','Table'[DeltaHebdoCAD]>-10000000 && 'Table'[DeltaHebdoCAD]<=-1000000))
Thank you,
Solved! Go to Solution.
Give this a try.
Weekly1M := CALCULATE( [Weekly Delta], ABS('Table'[DeltaHebdoCAD]) < 10000000, ABS('Table'[DeltaHebdoCAD]) >= 1000000 )
I'm not sure what you are asking. The ABS function i've used is for an Absolute Value. That means that both negative and positve numbers are counted as positive numbers.
If i understand you correctly, simply need a formula that is
Net Position = ABS(SUM('Table'[DeltaHebdoCAD]))
Give this a try.
Weekly1M := CALCULATE( [Weekly Delta], ABS('Table'[DeltaHebdoCAD]) < 10000000, ABS('Table'[DeltaHebdoCAD]) >= 1000000 )
Thank you for taking the time to awnser me Ross.
Your measure works, bu there is something I forgot to mention.
What if I needed to retain only net position of every group in my sum?
Let's say I have 3 groups, A B and C with the following numbers associated.
My ultimate goal is here is to show net position of groups that have a net position of less than 10M but over 1M (In absolute numbers).
Regards,
I'm not sure what you are asking. The ABS function i've used is for an Absolute Value. That means that both negative and positve numbers are counted as positive numbers.
If i understand you correctly, simply need a formula that is
Net Position = ABS(SUM('Table'[DeltaHebdoCAD]))
User | Count |
---|---|
119 | |
78 | |
59 | |
52 | |
48 |
User | Count |
---|---|
171 | |
118 | |
60 | |
59 | |
54 |