Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears
I have a bar chart showing customer and overdue amount, however I need to exclude 2 customers.
I am using this script which is showing all customers
if(Sum({<OverDueStatus={'Overdue'}>}[AmountFinal])<>0,Sum({<OverDueStatus={'Overdue'}>}[AmountFinal]))
Looking Forward to your reply.
Raaj
May be this
if(Sum({<OverDueStatus={'Overdue'}, Customer -= {'Cust1', 'Cust2'}>}[AmountFinal])<>0,Sum({<OverDueStatus={'Overdue'}, Customer -= {'Cust1', 'Cust2'}>}[AmountFinal]))
Sunny,
Excellent, it works.
Cheers man.
Raaj
Great