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 their key, which are: 1 and 3 respectively: https://gyazo.com/60cdcb7aa45052a1e55a199b665618be
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.
4 Replies
- amitchandak
Super User
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])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
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
Community Champion
you could do
measure =
VAR measure = measure1 + measure2
RETURN
CALCULATE ( measure, FILTER ( table, NOT ( customerkey IN { "one", "two" } ) ) )
