Forum Discussion
Analitika
Post Prodigy
Post ProdigyRemove not needed rows
Need to remove not needed rows and have no + signs https://easyupload.io/fn5yc2
Hi Analitika ,
Modify your [4_5 BP] measure like this:
4_5_BP = IF ( ISINSCOPE ( Table1[sas_kod] ), SWITCH ( SELECTEDVALUE ( Table22[Name BP] ), "Sales", 1, "Costs", 2, "Profit", BLANK (), "BP marge %", BLANK () ), IF ( ISINSCOPE ( Table22[Name BP] ), SWITCH ( SELECTEDVALUE ( Table22[Name BP] ), "Sales", 1, "Costs", 2, "Profit", 3, "BP marge %", 4 ) ) )In addition, +signs cannot be removed.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
v-yingjl
Community Support
Community SupportHi Analitika ,
Modify your [4_5 BP] measure like this:
4_5_BP =
IF (
ISINSCOPE ( Table1[sas_kod] ),
SWITCH (
SELECTEDVALUE ( Table22[Name BP] ),
"Sales", 1,
"Costs", 2,
"Profit", BLANK (),
"BP marge %", BLANK ()
),
IF (
ISINSCOPE ( Table22[Name BP] ),
SWITCH (
SELECTEDVALUE ( Table22[Name BP] ),
"Sales", 1,
"Costs", 2,
"Profit", 3,
"BP marge %", 4
)
)
)In addition, +signs cannot be removed.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Analitika
TY, it works only with columns, if Scope is something like
IF( sas_kod = "others", related(Table2[name]), related(Table3[name]))it stop working
