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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kilala
Resolver I
Resolver I

Conditional Calculation Based on Category

Hi all, 

 

I have quite complicated logic that I need to apply.

 

In his scenario, I have table Brand with their revenue amount. 

 

I need to re-allocate "Default" to brand where revenue > 0, except for D. Brand D is automatically excluded from reallocation no matter if its revenue >0.

 

For example:

BrandAmount
A3000
B-2000
C8000
D2000
Default-1000

 

In this case, I need to allocate Default(-1000) to Brand A and C only. How do I do the condition based on logic stated? Please help:(

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @kilala 

 

You can try the following methods.

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Brand] ) = "D",
    SELECTEDVALUE ( 'Table'[Amount] ),
    IF (
        SELECTEDVALUE ( 'Table'[Amount] ) > 0,
        -1000,
        SELECTEDVALUE ( 'Table'[Amount] )
    )
)

vzhangti_0-1645067634311.png

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-zhangti
Community Support
Community Support

Hi, @kilala 

 

You can try the following methods.

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Brand] ) = "D",
    SELECTEDVALUE ( 'Table'[Amount] ),
    IF (
        SELECTEDVALUE ( 'Table'[Amount] ) > 0,
        -1000,
        SELECTEDVALUE ( 'Table'[Amount] )
    )
)

vzhangti_0-1645067634311.png

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Please Try This
Screenshot 2022-02-14 140755.png

Hi @Anonymous ,

thank you for your suggestion, but currently i'm not able to add new column as i connect to live dataset. I can only create measures here. i think to use filter but it cannot return multiple columns. 

 

Anonymous
Not applicable

ok, Try it

Measure =
IF (
    SELECTEDVALUE ( 'Table (3)'[Brand] ) = "D",
    SELECTEDVALUE ( 'Table (3)'[Brand] ),
    IF (
        SELECTEDVALUE ( 'Table (3)'[Amount] ) > 0,
        "Default",
        SELECTEDVALUE ( 'Table (3)'[Brand] )
    )
)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.