Forum Discussion

ravindrajal's avatar
ravindrajal
Frequent Visitor
9 years ago

Select dynamic measures based on Time Hiearchy during drill down

Hi,

 

I have a requirement where the employee count based on his working hours has to be calculated for every 15 minutes and should be able to drillup to 30 mins and 1 hour.

 

I am able to calculate the employee count for 15 mins. But if the employee worked continously for 1 hour when i try to drll up to 1 hour instead of showing as 1 it is showing 4 as the count. 

For this reason i have calculated employee count in a seperate columns for every 15 ,30 mins and 1 hour. But how can i use these three measures on the same chart based on the drill down dimension column.

 

Can any one help me if there is a way to select measure column dynamically based on the drilldown column?

 

Thanks,

RJ

 

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi ravindrajal,

     

    It is not able to dynamically select a measure based on the drill down level. We can only control which measure to be displayed in a chart based on slicer, you could refer to: How to show dynamic measures on a chart using the slicer option

     

    In your scenario, you said "drll up to 1 hour instead of showing as 1 it is showing 4 as the count", if using DISTINCTCOUNT rather than COUNT to calculate the employee count , what is the result?

     

    Best regards,
    Yuliana Gu