Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Drill up/Drill down

I have a static Target value (=45) for every month of the year. I want to keep the value as it is when drilled up to month level but when drilled down to week level, I want the target value divided b...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    This may not be possible with DAX, as Drill up/Drill down does not enable data transfer with DAX. But I can offer you a workaround where you can switch the aggregation method to get different results. For example, Drill down uses the average value and Drill up uses the maximum value and you can check the results as follows:

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

This may not be possible with DAX, as Drill up/Drill down does not enable data transfer with DAX. But I can offer you a workaround where you can switch the aggregation method to get different results. For example, Drill down uses the average value and Drill up uses the maximum value and you can check the results as follows:

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.