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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.