Adjusting measure to with filter

[Talal141218]

Hello Community, 

I need your help to correct my measure or create a new one to suit the filter, that i will select it. 

B2C Geschäft von G.S % =

var B2C = CALCULATE([CM_SalesLine_SalesOrderLine_AmountSales_ExclAll_LCY], Fact_SalesLine[SalesOrderLineOrderTypeName]= "B2C Dropshipping" )+ CALCULATE([CM_SalesLine_SalesOrderLine_AmountSales_ExclAll_LCY],Fact_SalesLine[SalesOrderLineOrderTypeName] = "b2c Bulk")

var Gesamtorderamount = Fact_SalesLine[CM_SalesLine_SalesOrderLine_AmountSales_ExclAll_LCY]

return DIVIDE(B2C, Gesamtorderamount).

Filter as you see in the screen shot:

When i want to select one of the filter above, will give me unrealistic results or ratio. 

Thanks in Advance

[bhanu_gautam]

@Talal141218 , Try using 

B2C Geschäft von G.S % =
VAR B2C =
CALCULATE(
[CM_SalesLine_SalesOrderLine_AmountSales_ExclAll_LCY],
Fact_SalesLine[SalesOrderLineOrderTypeName] IN {"B2C Dropshipping", "b2c Bulk"}
)
VAR Gesamtorderamount =
CALCULATE(
[CM_SalesLine_SalesOrderLine_AmountSales_ExclAll_LCY],
ALL(Fact_SalesLine[SalesOrderLineOrderTypeName])
)
RETURN
DIVIDE(B2C, Gesamtorderamount)

[Talal141218]

The same result. Thx for trying. 

[Anonymous]

Hi @Talal141218 ,

Try to add allselected() when there is a table calculation and if you still have problems, please share the sample data as well as the expected results.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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