New measure filter by cost center and month

[sur27078]

Hi,

I am new with this Var command and I am trying to do % calculation from Single column. I have the following New measure but it seems calculate all number. How can I filter based on Cost_Center and Month when I splice in table?

The result should be 0.42 which translate to 42% ( Total sum of rc and projected cost divided by rc)

Gross Margin % =

VAR _TotalRevenue = CALCULATE( SUM( 'GL_Balance_MC (2)'[ReverseBalance]), FILTER( ALL( 'GL_Balance_MC (2)' ), [Code] IN { "rc" } ) )

VAR _GrossMargin = CALCULATE( SUM( 'GL_Balance_MC (2)'[ReverseBalance] ), FILTER( ALL( 'GL_Balance_MC (2)' ), [Code] IN { "rc", "projectcost" } ) )

VAR _Return = DIVIDE( _GrossMargin, _TotalRevenue, 0 )

RETURN _Return

Thanks

Sur

[sur27078 · Accepted solution]

@Irwan Thank you. I just realized that. I changed to "ALLSELECTED" and it seems working. 

[v-saisrao-msft]

Hi @sur27078,

Thank you for the update. Glad to hear that ALLSELECTED worked for you. If you encounter any other issues or need more clarification, feel free to reach out. We're here to assist.

Thank you.

[Irwan]

hello @sur27078 

it seems because of ALL function.

here is a simple example.

measure with ALL inside FILTER will have same value.

measure without ALL inside FILTER will have vary result because the value will depend on applied filter.

Hope this will help.

Thank you.