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.
Account Name | Date | Amount |
Rev | 12-Jun-18 | 430 |
Exp | 13-Aug-17 | 250 |
Margin | 2-Mar-17 | 0 |
Rev | 12 July 18 | 400 |
Exp | 13-Aug-17 | 300 |
I have a table where I need to create a calculated measure based on the below logic
If the Account Name <> 'Margin' then Sum of amount
if the Account Name = "Margin' then Sum of amount =
Sum of Amount when account name is 'Rev' - Sum of Amount when account name is 'Exp'
try this
Measure = IF ( SELECTEDVALUE ( 'Table'[Account Name] ) = "Margin", CALCULATE ( SUM ( 'Table'[Amount] ), 'Table'[Account Name] = "Rev" ) - CALCULATE ( SUM ( 'Table'[Amount] ), 'Table'[Account Name] = "Exp" ), SUM ( 'Table'[Amount] ) )
if you have more cases like this it may be better to embed the logic in a new table, e.g. like this:
Measure | Positive | Negative |
Margin | Rev | Exp |
Margin2 | Rev | Exp2 |
something similar to what's described here:
https://community.powerbi.com/t5/Desktop/Create-calculated-row/td-p/440613
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 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |