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 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:
Brand | Amount |
A | 3000 |
B | -2000 |
C | 8000 |
D | 2000 |
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:(
Solved! Go to Solution.
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] )
)
)
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.
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] )
)
)
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.
Please Try This
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.
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] )
)
)
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 |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |