Measure is showing the same value for each month even though inputs are different

[Anonymous]

I am trying to calculate the cost savings from using one team to answer calls vs another team. 

I calculate the average call length and then the total calls they can respond to during the time period selected in the date heirarchy. 

In the case of this table, for the month of March 2021 our team had access to 20,760 minutes per month with 2 teams running. At 58 minutes per call they could have responded to 716 calls that month. The cost per call is $99.33 which means it would cost us $71,120.28 to answer those calls. However in the table its copied 71,159.89. It only switched to around 35,000 when theres only 1 team. 

Avg. Call Length = AVERAGE('Data Table'[Call Length])
-----
Max Capacity (All Teams) = 
SWITCH(
    TRUE(),
    ISFILTERED('Rolling Calendar'[Start of Year]), DIVIDE(249600, [Avg. Call Length])*[Total Teams],
    ISFILTERED('Rolling Calendar'[Start of Month]), DIVIDE(20760, [Avg. Call Length])*[Total Teams],
    ISFILTERED('Rolling Calendar'[Start of Week Monday]), DIVIDE(4800, [Avg. Call Length])*[Total Teams],
    BLANK()  -- Default to monthly if no specific drill level is detected
)

Note: The average minutes per time period is divided by the average call length for that time period. 
-----
Out Team Cost Per Call = 
SWITCH(
    TRUE(),
    ISFILTERED('Rolling Calendar'[Start of Year]), ([Avg. Call Length]*1.713870353),
    ISFILTERED('Rolling Calendar'[Start of Month]), ([Avg. Call Length]*1.713870353),
    ISFILTERED('Rolling Calendar'[Start of Week Monday]), ([Avg. Call Length]*1.713870353),
    BLANK()-- Default to monthly if no specific drill level is detected
)

Note: 1.713870353 is the cost per minute to run one team. 

-----
Max Cap. Cost (All Teams) = [Max Capacity (All Teams)]*[Out Team Cost Per Call]

-----

Max Cap. Other Team Cost = [Max Capacity (All Teams)]*(49*3.359102564)


Note: (49*3.359102564) Is the cost per call for this other team. Their average call length is 49 minutes. 

----

Max Cap. Cost Savings = [Max Cap. Other Team Cost]-[Max Cap. Cost (All Teams)]

[v-kongfanf-msft]

Hi @Anonymous ,

What does your data model look like and can you provide more descriptive information?

Best Regards,
Adamk Kong

[Anonymous]

You want to know the tables I have and the relationships between them? 

i have my rolling calendar and the main data table connected on the date with a one to many relationship.