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,
I need some help on sum the Negative and Positive values within a measure seperately.
Eg. I have the following measure
Difference |
-0.4375 |
0 |
0 |
0 |
-0.2 |
0 |
0.7875 |
0.055 |
-0.77875 |
0.5 |
0.3 |
0 |
0 |
-0.8 |
-0.125 |
0.1125 |
-0.2 |
Since it a measure I have problems in using the CALCULATE or SUM or any other ways to calculate the sum, I nee to calculate only the negative values and have it in a measure then sum the psoitive values and have it in a different measure.
Result should be -254 for negative sum and 1.7 for the positive.
Please it would be great if some one could help me.
Solved! Go to Solution.
Sorry I overlooked that it is a MEASURE
Which column do you use as row field
Try this. Replace the Column with RowField
PositiveCount = SUMX ( FILTER ( ALLSELECTED ( TableName[COLUMN] ), [Difference] > 0 ), [Difference] )
i have a same problem but i dont understand what do you mean "Replace the Column with RowField"?@Zubair_Muhammad
Hope! this is what you're looking for,
Posstive = CALCULATE(SUM(Table1[Difference]),Table1[Difference] > 0)
Negative = CALCULATE(SUM(Table1[Difference]),Table1[Difference] < 0)
@SivaMani thaks for the reply
I have tried this earlier with lot other however the problem was that the difference column shown itself is a measure not the column and so it is not possible to use the measure in place of column, any other thoughts?,
I brought the negative and positive values in a speperate measures respectively but you know the total will not be the one as expecteed in a measure put up like this,, so stuck here....
Try this
PositiveCount = CALCULATE ( SUM ( TableName[Difference] ), TableName[Difference] > 0 )
@Zubair_Muhammad Thanks for your reply,
Here you mean the column
SUM ( TableName[Difference]
However mine was a measure (The difference Iam calculating is already withing a measure), I not able to use a measure here.
Sorry I overlooked that it is a MEASURE
Which column do you use as row field
Try this. Replace the Column with RowField
PositiveCount = SUMX ( FILTER ( ALLSELECTED ( TableName[COLUMN] ), [Difference] > 0 ), [Difference] )
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |