Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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] )
)
)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!