Forum Discussion

GregoryDF's avatar
GregoryDF
Frequent Visitor
10 years ago
Solved

How to create dynamic measures that updates when drilling down in data?

Hello everyone,

 

I've built some reports with geographical or products ranges drill-down "hierarchies" and I have a problem with my global measures that, as they should in some way, stay global even when I'm drilling down on my data.

 

Here is an example :

I have a bar graph with my distinct regions as the dimension, and count of customers as the value. When drilling down on region, I go to territory, then customer.

The graph is working well, no issue with it, as the count of customer is always updated to reflect each component.

But I put this same measure as a card under the graph, and it always keep the same value when I'm drilling down on data.

 

How to get it to update itself to represent the data currently drilled-down on?

 

Thanks for your help :)

4 Replies

  • greggyb's avatar
    greggyb
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    Drilling down into one visual only applies a filter to that specific visual. If you'd like to apply filters to the entire page, you'll need to utilize page-level filters, slicers, or cross-filtering and cross-highlighting based on visual selections.

    • GregoryDF's avatar
      GregoryDF
      Frequent Visitor
      10 years ago

      Thanks :)

       

      That's what I thought also, but it would be great to be able to have the drill down filter on the page level instead of only visual, or at least to have the ability to configure the behaviour we need for each report/dashboard.

       

      I see there is an existing idea about that, I'll put some votes on it :)

      https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6709520-drill-down-should-drill-or-cross-filter-other-visu

       

      • Raulpt27's avatar
        Raulpt27
        Regular Visitor
        10 years ago

        Hi 

         

        Everone

         

        I  was  creating a  new mesure, but  i  have  this  error "The syntax for ':' is incorrect. (DAX(
        IF( SUM(AHT[Tiempo Retiradas Almuerzo]) - SUM(AHT[Tiempo Objetivo de Almuerzo]) = 01:00:00. 0 ,SUM(AHT[Tiempo Retiradas Almuerzo]) - SUM(AHT[Tiempo Objetivo de Almuerzo]))
        )).", i need  to do a subtration  of Time 1 ( Retiradas) - Time 2 ( Time Obj), and  i have a  result 01:00:00(hh:mm:ss), it show me  thta  person dont have  time  of lunch, i wnat  to  use  IF  to put off( 01:00:00) for  0.

         

        Somebody  can help me?

         

        Thanks!