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 with measure 😑.
I have a problem creating a measure where I can summarize transactions by item number and then use the result for items that have negative value and in another measure positive value. It is important to show positive and negative values separately, becouse I would like to use this measure in visual as Card.
In the table, I have managed to resolve this issue, but I need to use it in a Card where I couldn't get value for positive and negative separately
Example (Items can appear multiple times with different values. The value must be summerized by items and then sum the positive values and negative values separately)
Item No. | Quantity | Value |
642010 | 2 | 1000 |
642010 | -1 | -500 |
656132 | 5 | 1500 |
689033 | -7 | -570 |
Positive value would be 2000
Negative value would be -570.
Thank you all for your help and answers
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
Item value only positive: =
SUMX (
FILTER (
ADDCOLUMNS (
DISTINCT ( Data[Item No.] ),
"@values", CALCULATE ( SUM ( Data[Value] ) )
),
[@values] > 0
),
[@values]
)
Item value only negative: =
SUMX (
FILTER (
ADDCOLUMNS (
DISTINCT ( Data[Item No.] ),
"@values", CALCULATE ( SUM ( Data[Value] ) )
),
[@values] < 0
),
[@values]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
Item value only positive: =
SUMX (
FILTER (
ADDCOLUMNS (
DISTINCT ( Data[Item No.] ),
"@values", CALCULATE ( SUM ( Data[Value] ) )
),
[@values] > 0
),
[@values]
)
Item value only negative: =
SUMX (
FILTER (
ADDCOLUMNS (
DISTINCT ( Data[Item No.] ),
"@values", CALCULATE ( SUM ( Data[Value] ) )
),
[@values] < 0
),
[@values]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |