Exclude customer from total billing

[Anonymous]

Good

Could two customers somehow be excluded from total billing?

My dax measure for calculating total billing is: https://gyazo.com/170750e5e8236d14d59d95b4108b1c82

Both clients have their key, which are: 1 and 3 respectively: https://gyazo.com/60cdcb7aa45052a1e55a199b665618be

[vanessafvg]

you could do 

measure =
VAR measure = measure1 + measure2
RETURN
    CALCULATE ( measure, FILTER ( table, NOT ( customerkey IN { "one", "two" } ) ) )

[amitchandak]

@Anonymous , You can have measure like

example

filter meausre = calculate([Total Facturation], filter(Table, not(Table[customer] in {"Customer1","Customer2"})))

OR only remove in grand total

if(isfiltered(Table[customer]) ,[Total Facturation],[filter meausre])

[Anonymous]

I didn't quite understand your answer.

I'll let you capture the clients and the tables. The goal is that customers with Key "1" and "3" are not counted for full billing.

https://gyazo.com/79c43b8933cf769cfeb8e2aef8ed228f

https://gyazo.com/4fec3053e532392f5b84763a68ee9121

https://gyazo.com/892de8128d60ef2a64474743d0141234

[Icey · Accepted solution]

Hello @Alejandro-Glez ,

Try to create another measure based on your"Total Billing" measurelike this:

Measure =
CALCULATE (
    [Total Facturacion],
    FILTER ( FactVentas, NOT ( FactVentas[ClientKey] IN { 1, 3 } ) )
)

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.