Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Calculated Measure

Account NameDateAmount
Rev12-Jun-18430
Exp13-Aug-17250
Margin2-Mar-170
Rev12 July 18400
Exp13-Aug-17300

 

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'

1 REPLY 1
Stachu
Community Champion
Community Champion

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:

MeasurePositiveNegative
MarginRevExp
Margin2RevExp2

something similar to what's described here:
https://community.powerbi.com/t5/Desktop/Create-calculated-row/td-p/440613



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors