Forum Discussion
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...
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.
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
Icey
Community Support
Community SupportHello @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.