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,
this time i would like to ask you to support me in following case:
inputa table
Expected table - works well
Measure to improve
Result of measure
How to update syntax in measure to have
calculated total sum by category and have posibilities to add extra value to each category.
Thank you in advance for your reply.
Solved! Go to Solution.
My first thought was that you just need to move "+ 100" inside SUMX but that would give 407, not 307.
You need to iterate at the level you want to sum at (Category).
CategorySum =
SUMX (
VALUES ( 'Table'[Category] ),
CALCULATE ( SUM ( 'Table'[Value] ) + 100 )
)
My first thought was that you just need to move "+ 100" inside SUMX but that would give 407, not 307.
You need to iterate at the level you want to sum at (Category).
CategorySum =
SUMX (
VALUES ( 'Table'[Category] ),
CALCULATE ( SUM ( 'Table'[Value] ) + 100 )
)
@Anonymous try this
Measure =
SUMX (
ADDCOLUMNS (
VALUES ( 'Table'[Category] ),
"sum", CALCULATE ( SUM ( 'Table'[Value] ) ) + 100
),
[sum]
)
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 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |