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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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])

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    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.