Conditional Formatting BI

[SurferJames]

I am fairly new to BI.

I have a table that has the following contents:

- Orginated time (This is when the call hit)

- Orginator (Customer number)

- Customer

- Age

- Any Disability (Flagged as 'Y' or 'N)

I need to create the following conditional formatting

- Any customer that has called more than ten times in a single month = red 

- Any customer that has called us more than 5 times in 7 days = yellow/amber

- Any customer that is over 65 and called us more than 5 times in 7 days = red

I haven't created any measures or date tables to reference single month or 7 days along with measures to create the conditional formatting.

Any help will be greatly appreciated.

Thanks,

James

[JoeBarry]

Hi @SurferJames 

I'm trying to undestand the 7 days part, is it the last 7 days or is it any 7 day period in a month? 

[SurferJames]

I have created two measures like this:

1.

Last 30 Days = VAR startdate = TODAY() - 30

return

CALCULATE(COUNT('Contact Log'[Originator]),'Contact Log'[Originated Time]>= startdate)

2. 

Last 7 Days = VAR startdate = TODAY() - 7

return

CALCULATE(COUNT('Contact Log'[Originator]),'Contact Log'[Originated Time]>= startdate)

Now I want to conditional format it but I can't seem to use two measures, how would I combine them with the rules I want in the original message?