Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Exclude customer from total billing

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 th...
  • Icey's avatar
    Icey
    5 years ago

    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.

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

you could do 

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