calculates number of customers who have an amount greater than 0 per week day

[hguetaf]

hello everyone i really need your lights on the topic,
to clearly explain the need:
I have two tables 1) Customer and 2) Sales + a calendar table that I created
I wanted to calculate the number of customers who made sales during the week 

it should be look like " 

Mesure = CALCULATE(COUNTA(Consumer'[ID]) , count(Day) if Sale[Amount] > 0)

Thank you

[ribisht17]

@hguetaf 

I have 3 customers out of 4  with +Profit

EARLIER

AFTER FILTER

NOTE

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users