Use slicer for calculated columns

[Anonymous]

llo

I have created a calculated column showing how many in running calls there are at 15 minute intervals throughout the day. I have a date table with the intervals and another table with the start date/time and end date/time of the calls and caller ids etc. I have manged to add the results to the date table where it shows me how many calls are at each interval.

When I try to use Slicers/Filters from the other table, the values created from the calulated column do not change. I noticed with measures that the value changes, but i have tried to replicate the calculated column as a measure,  but it doesn't give the desired results.

For the Calculated column I used the following DAX formula

In running calls =

CALCULATE(COUNTROWS('Calls'),
FILTER('Calls', ([START_DATE] <= ('Date'[DateTime])
&& [End Time]>= ('Date'[DateTime]))))

Is there anyway of converting this to a measure? 

Thanking you in advance

[v-piga-msft]

Hi @Anonymous,

If it is convenient, could you share some data sample and your desired output so that we could help further on it?

Best Regards,

Cherry

[Anonymous]

Hello Cherry @v-piga-msft

I have a table with Date/ Time like below in 15 Minute intervals. 

Date/Time

01/01/2016 00:00

01/01/2016 00:15

I also have another Table with Start & End Times.

      Start Time                   EndTime

01/01/2016 00:00         01/01/2016 01:00

01/01/2016 00:00         01/01/2016 02:00

01/01/2016 00:00         01/01/2016 03:00

01/01/2016 00:00         01/01/2016 03:00

01/01/2016 00:00         01/01/2016 03:00

I have already managed to add a column to the date/time table that shows how many times, either the Start Time or End Time fall on that particular time in the date/time table. The result is lets say

Date/Time                                    Concurrency

01/01/2016 00:00                               5

01/01/2016 00:15                               5

01/01/2016 00:30                               5

01/01/2016 00:45                               5

01/01/2016 01:00                               5

01/01/2016 01:15                               4

This way is fine if i am looking for an overall picture, but i face problems when I try to use slicers/filters. The Concurrency values stay the same. 

In my orginal question, I mentioned that measures change when a slicer is used. I would like to have a measure that gives me the same results if possible

Thanks

Joe

[Greg_Deckler]

Calculated columns are calculated at the time of data load and never again. You need to use measures which are calculated dynamically.